COALESCE Function [Miscellaneous]

Returns the first non-NULL expression from a list.

Syntax

COALESCE ( expression, expression [ , … ] )

Parameters

Parameters

Parameter

Description

expression

Any expression.

Returns

ANY

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.

Parent topic: Alphabetical List of Functions
Related reference
ISNULL Function [Miscellaneous]