COALESCE function [Miscellaneous]

Returns the first non-NULL expression from a list.

COALESCE ( expression, expression [ , … ] )

The following statement returns the value 34:

SELECT COALESCE( NULL, 34, 13, 0 ) FROM iq_dummy