NULL Predicate

From Recital Documentation Wiki
(Redirected from NULL PREDICATE)
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