COALESCE

Use COALESCE to evaluate arguments in order from left to right. The result is the first non-null value.

The COALESCE function requires a minimum of two arguments. The data type of the result is based on the data type of the arguments.

COALESCE(argument1, argument2, argument3)