Progress
SQL-92
Guide and Reference
COALESCE Function
Specifies a series of expressions, and returns the first expression whose value is not null. If all the expressions evaluate as null, COALESCE returns a null value.
SYNTAX
NOTE: The COALESCE syntax is shorthand notation for a common case that can also be represented in a CASE expression. The following two formulations are equivalent:
EXAMPLE
This example illustrates the COALESCE function:
NOTES
COMPATIBILITY
SQL-92 Compatible
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |