OQL COALESCE

The COALESCE function returns the first of its arguments that is not null.

The syntax is as follows:

COALESCE ( expression [ ,...n ] )

expression Specifies the expression to check if the result is NULL.