Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » UltraLite - Database Management and Reference » UltraLite SQL Reference » UltraLite SQL functions » SQL functions (A-D)

 

COALESCE function [Miscellaneous]

Returns the first non-NULL expression from a list. This function is identical to the ISNULL function.

Syntax
COALESCE( expression, expression [ , ...] )
Parameters
  • expression   Any expression.

    At least two expressions must be passed into the function, and all expressions must be comparable.

Returns

ANY

Remarks

The result is NULL only if all the arguments are NULL.

The parameters can be of any scalar type, but not necessarily same type.

For a more detailed description of how the database server processes this function, see ISNULL function [Miscellaneous].

See also
Standards and compatibility
  • SQL/2003   Core feature.

Example

The following statement returns the value 34.

SELECT COALESCE( NULL, 34, 13, 0 );