Difference between revisions of "ISNULL()"
From Lianjapedia
Helen.george (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
Line 6: | Line 6: | ||
==See Also== | ==See Also== | ||
− | [[EMPTY()]], [[IFNULL()]], [[ISALPHA()]], [[ISBLANK()]], [[ISDIGIT()]], [[NVL()]], [[SET NULL]], [[SET NULLDISPLAY]] | + | [[COALESCE()]], [[EMPTY()]], [[IFNULL()]], [[ISALPHA()]], [[ISBLANK()]], [[ISDIGIT()]], [[NVL()]], [[SET NULL]], [[SET NULLDISPLAY]] |
==Description== | ==Description== |
Revision as of 08:56, 27 March 2013
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;