ISNULL()

From Recital Documentation Wiki
Revision as of 12:28, 23 March 2009 by Yvonnemilne (Talk | contribs)

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

Class

Expressions and Type Conversion


Purpose

Function to test if an expression evaluates to NULL


Syntax

ISNULL(<expr>)


See Also

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


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