COALESCE function [Miscellaneous]

Function

Returns the first non-NULL expression from a list.

Syntax

COALESCE ( expression, expression [ , … ] )

Parameters

expression Any expression

Example

The following statement returns the value 34:

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

Standards and compatibility

SQL ISO/ANSI SQL compliant.

Sybase Compatible with Adaptive Server Enterprise.