COALESCE( expression, expression [ , ...] )

ANY

The result is NULL only if all the arguments are NULL.

The parameters can be of any scalar type, but not necessarily same type.

For a more detailed description of how the database server processes this function, see ISNULL function [Miscellaneous].

• ISNULL function [Miscellaneous]

The following statement returns the value 34.

SELECT COALESCE( NULL, 34, 13, 0 );