COALESCE Function

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(expr_1, expr_2,...expr_n)