NULL Predicate

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