ISNULL()

Class

Expressions and Type Conversion

Purpose

Function to test if an expression evaluates to NULL

Syntax

ISNULL(<expr>)

See Also

EMPTY(), ISALPHA(), ISBLANK(), ISDIGIT(), NVL()

Description

The ISNULL() function will return True (.T.) if the specified expression, <expr> is NULL otherwise False (.F.).

Example

select account_no, isnull(last_name) from customer;

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer