Coalesce

The coalesce function returns the first non-null expression in the list. If all expressions evaluate to null, then the coalesce function will return null.

Syntax:

COALESCE (expression_1, expression_2, ...,expression_n).