COALESCE scalar function - Db2 SQL

COALESCE Function Function returns the first non-missing value found in an array of columns The order of the columns listed in the function determines the

The Coalesce function returns the value of the first argument that is not Null This function is often applied to one or more columns of data to check for

coalesce Returns the value of the first non-null expression in the list If all expressions evaluate to null, then COALESCE returns null

coalesce Returns the value of the first non-null expression in the list If all expressions evaluate to null, then COALESCE returns null