The COALESCE function returns the first of its arguments that is not null.
Signatures & examples
COALESCE(value [, ...])
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:Version history 1