Difference between revisions of "ISNULL()"

From Recital Documentation Wiki
Jump to: navigation, search
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