Progress
Embedded SQL-92
Guide and Reference


NULL Values in Expressions

You can use expressions in the SELECT list for retrieving NULL values. If any value that participates in an arithmetic expression is NULL, the value of the entire expression is NULL, as this example illustrates:

EXEC SQL
     SELECT ename, sal, sal + commission
     FROM employee
     WHERE empno = 2452 ; 

In this example, if the commission for empno 2452 is NULL, then the value of the expression sal + commission in the SELECT list evaluates to NULL.


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