NULL Predicate

From Recital Documentation Wiki
Revision as of 15:46, 13 March 2009 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

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