Progress
SQL-92
Guide and Reference
NVL Function
Returns the value of the first expression if the first expression value is not null. If the first expression value is null, the value of the second expression is returned.
SYNTAX
NOTE: The NVL function is not ODBC compatible. Use the IFNULL function when ODBC-compatible syntax is required.EXAMPLEThis example illustrates the NVL function:
NOTES
COMPATIBILITY
Progress Extension
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |