Difference between revisions of "ISNULL()"
From Lianjapedia
Helen.george (Talk | contribs) |
|||
Line 18: | Line 18: | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
− | [[Category: | + | [[Category:Formatting Functions]] |
− | + |
Revision as of 08:17, 4 February 2013
Contents
Purpose
Function to test if an expression evaluates to NULL
Syntax
ISNULL(<expr>)
See Also
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;