Difference between revisions of "ISNULL()"

From Recital Documentation Wiki
Jump to: navigation, search
 
(One intermediate revision by one user not shown)
Line 1: Line 1:
==Class==
 
Expressions and Type Conversion
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to test if an expression evaluates to NULL
 
Function to test if an expression evaluates to NULL
Line 26: Line 22:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
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