Name
coalesce() — Return first non-NULL argument
Common Usage
coalesce( param1, param2, ... )
Description
The coalesce() function takes two or more
parameters and returns the first non-NULL parameter. If all of the
parameter values are NULL, a NULL is returned.