ISNULL()
From Lianjapedia
Revision as of 08:56, 27 March 2013 by Yvonne.milne (Talk | contribs)
Contents
Purpose
Function to test if an expression evaluates to NULL
Syntax
ISNULL(<expr>)
See Also
COALESCE(), EMPTY(), IFNULL(), 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;