Difference between revisions of "ISNULL()"
From Recital Documentation Wiki
		
		
		
Yvonnemilne  (Talk | contribs)  | 
				Yvonnemilne  (Talk | contribs)   | 
				||
| Line 12: | Line 12: | ||
==See Also==  | ==See Also==  | ||
| − | [[EMPTY()]], [[ISALPHA()]], [[ISBLANK()]], [[ISDIGIT()]], [[NVL()]]  | + | [[EMPTY()]], [[ISALPHA()]], [[ISBLANK()]], [[ISDIGIT()]], [[NVL()]], [[SET NULL]], [[SET NULLDISPLAY]]  | 
Revision as of 11:47, 9 June 2009
Class
Expressions and Type Conversion
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 Database Server, Recital Mirage Server, Recital Terminal Developer