Difference between revisions of "ISNULL()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Function to test if an expression evaluates to NULL | Function to test if an expression evaluates to NULL | ||
| Line 12: | Line 8: | ||
==See Also== | ==See Also== | ||
| − | [[EMPTY()]], [[ISALPHA()]], [[ISBLANK()]], [[ISDIGIT()]], [[NVL()]] | + | [[EMPTY()]], [[ISALPHA()]], [[ISBLANK()]], [[ISDIGIT()]], [[NVL()]], [[SET NULL]], [[SET NULLDISPLAY]] |
| Line 26: | Line 22: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
[[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]] | ||
Latest revision as of 16:44, 2 December 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 Server, Recital
