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:
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 |