Difference between revisions of "ISNULL()"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision) |
|||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to test if an expression evaluates to NULL | Function to test if an expression evaluates to NULL | ||
| − | |||
==Syntax== | ==Syntax== | ||
ISNULL(<expr>) | ISNULL(<expr>) | ||
| − | |||
==See Also== | ==See Also== | ||
| − | [[EMPTY()]], [[ISALPHA()]], [[ISBLANK()]], [[ISDIGIT()]], [[NVL()]], [[SET NULL]], [[SET NULLDISPLAY]] | + | [[EMPTY()]], [[IFNULL()]], [[ISALPHA()]], [[ISBLANK()]], [[ISDIGIT()]], [[NVL()]], [[SET NULL]], [[SET NULLDISPLAY]] |
| − | + | ||
==Description== | ==Description== | ||
The ISNULL() function will return True (.T.) if the specified expression, <expr> is NULL otherwise False (.F.). | The ISNULL() function will return True (.T.) if the specified expression, <expr> is NULL otherwise False (.F.). | ||
| − | |||
==Example== | ==Example== | ||
| Line 20: | Line 16: | ||
</code> | </code> | ||
| − | |||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:Expressions and Type Conversion]] | [[Category:Expressions and Type Conversion]] | ||
[[Category:Expressions and Type Conversion Functions]] | [[Category:Expressions and Type Conversion Functions]] | ||
Revision as of 07:14, 2 October 2012
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;
