NULL Predicate

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