This is an old revision of the document!


Omnidex SQL Function: COALESCE

Description

The COALESCE function returns the first non-NULL expression among its arguments.

This function returns the same datatype as the passed parameter. If all passed parameters are NULL, then this function returns a NULL.

Syntax

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

Required. An expression using SQL language that produces a value. A scalar expression is generally equivalent to a select item in the SQL SELECT statement, and can be a character expression, numeric expression or date expression.

Example

Example 1: COALESCE against columns

> select coalesce(name, individual) identifier from individuals;

IDENTIFIER
--------------------------------------------------
MS. MARY LEWIS
MRS. ALICE R TOLLIVER
MR. SIDNEY K TOLLIVER
MRS. JENNIFER J HOPKINS
MR. CHARLIE HOPKINS
MS. KIMBERLY BLUE
KATHLEEN TUCKER

Additional Resources

See also:

 
Back to top
dev/sql/functions/coalesce.1280263458.txt.gz ยท Last modified: 2016/06/28 22:38 (external edit)