Returns the first non-null expression from the list of supplied expressions.  If all expressions are NULL, returns NULL. The data types of the supplied expressions must be compatible.

 

Example:

SELECT COALESCE(NULL, NULL, 123, 456) returns 123