NULL Predicate

From Recital Documentation Wiki
Revision as of 17:21, 22 December 2009 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Purpose

Special predicate


Syntax

<expression> IS [NOT] NULL


See Also

INSERT, PREDICATES, 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

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, Recital Server