The COALESCE function returns the first of its arguments that is not null. Null is returned only if all arguments are null. It is often used to substitute a default value for null values when data is retrieved for display, for example:

COALESCE(value [, ...])

Like a CASE expression, COALESCE only ...