Syntax
IF_NULL(Argument1,Argument2)
Description
The IF_NULL SQL scalar function returns the first argument that is not null.
The arguments must be compatible. Character-string arguments are compatible with date/time values.
The arguments are evaluated in the order in which they are specified.
The result of the function is the first argument that is not null.
The result can be null only if all arguments can be null, and the result is null only if all arguments are null. The selected argument is converted, if necessary, to the attributes of the result.
Example
IF_NULL(SALARY,0) returns 0 if the salary is missing (that is, null)
List of SQL scalar functions by topic