Difference between revisions of "ISNULL()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) (→Class) |
||
Line 1: | Line 1: | ||
− | |||
− | |||
Revision as of 15:54, 27 October 2009
Purpose
Function to test if an expression evaluates to NULL
Syntax
ISNULL(<expr>)
See Also
EMPTY(), ISALPHA(), ISBLANK(), ISDIGIT(), NVL(), SET NULL, SET NULLDISPLAY
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