Progress
SQL-92
Guide and Reference
IFNULL Function
Returns value if expr is null. If expr is not null, IFNULL returns expr.
SYNTAX
EXAMPLE
This example illustrates the IFNULL function. The SELECT statement returns three rows with a NULL value in column C1, and two non-NULL values:
NOTE
COMPATIBILITY
ODBC Compatible
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |