ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

COALESCE function [Miscellaneous]

Function 

Returns the first non-NULL expression from a list.

Syntax 

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

Parameters 

expression    Any expression.

Standards and compatibility 

• SQL/92    SQL/92.

• SQL/99    Core feature.

• Sybase    Compatible with Adaptive Server Enterprise.

Example 

The following statement returns the value 34.

SELECT COALESCE( NULL, 34, 13, 0 )