Difference between revisions of "NULL Predicate"

From Recital Documentation Wiki
Jump to: navigation, search
 
Line 37: Line 37:
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:SQL]]
 
[[Category:SQL]]
[[Category:Reference]]
 

Revision as of 15:29, 13 March 2009

NULL PREDICATE

Class

SQL Applications


Purpose

Special predicate


Syntax

<expression> IS [NOT] NULL


See Also

PREDICATES, INSERT, SELECT, UPDATE


Description

NULL is a special predicate to evaluate whether the specified <expression> is NULL. The optional NOT can be used to evaluate whether the specified <expression> is not NULL.


Example

EXEC SQL
SELECT name, address, balance, cost*1.15
FROM accounts
WHERE paid_date < date() AND ord_value IS NULL
ORDER BY name, paid_date;


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer