For example, if result is an integer and default is a fractional number, DECODE returns a value with data type NUMERIC. If the data types of result and default are different, the data type returned is the type most compatible with all of the possible return values, the data type with the highest data type precedence. For numeric values, DECODE returns the largest length, precision, and scale from all of the possible result argument values. If the data type of the first result argument cannot be determined, DECODE returns VARCHAR. If you use DECODE to search for a value in a string port, you can either trim trailing blanks with the RTRIM function or include the blanks in the. You can build an unlimited number of searches within a DECODE function.

Data Type of Returned ValueĭECODE returns the data type of the first result argument. If the function finds the value, it returns a result value, which you define.

Note that DECODE is supported for Oracle compatibility. If expr is null, InterSystems IRIS returns the result of the first search that is also null. In a DECODE expression, InterSystems IRIS considers two nulls to be equivalent. Therefore, InterSystems IRIS never evaluates a search if a previous search is equal to expr. InterSystems IRIS evaluates each search value only before comparing it to expr, rather than evaluating all search values before comparing any of them to expr. If expr is not equal to any search value, the default value is returned, or, if default is omitted, null is returned. search is the value that is compared against. , default ) expression is the value to compare. If expr is equal to a search value, the corresponding result is returned. The syntax for the decode function is: decode ( expression, search, result, search, result. To evaluate a DECODE expression, InterSystems IRIS compares expr to each search value, one by one: The search, result, and default values can be derived from expressions. The maximum number of parameters in the DECODE expression (including expr, search, result, and default) is about 100. You can specify multiple search, result pairs, separated by commas. Optional - The default value which is returned if expr does not match any search. The value which is returned if expr matches search.

Decode sql