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

NVL ( expression , expression ) 

NOTE: The NVL function is not ODBC compatible. Use the IFNULL function when ODBC-compatible syntax is required.

EXAMPLE

This example illustrates the NVL function:

SELECT salary + NVL (comm, 0) ’TOTAL SALARY’ FROM employee ; 

NOTES

COMPATIBILITY

Progress Extension


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095