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