Functions and Directives

Function CoalesceEmpty() Foundation

Returns the first non empty expression among its arguments.

CoalesceEmpty( <Expression,...> ) --> <Expression>
Can be an expression of any type.

Returns the first non empty value of its arguments evaluated from the left to the right most parameter passed. If all expressions evaluate an empty value, the function returns NIL.


The function CoalesceEmpty() is used to determine the first non empty value from of a set of values. Instead of using the function CoalesceEmpty() the programmer can use IF/ELSEIF statements. However using nested IF statements in database expressions is not possible and therefore does require a user defined function which can be avoided using the function CoalesceEmpty().


If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.