Difference between revisions of "ISNULL()"

From Lianjapedia
Jump to: navigation, search
Line 18: Line 18:
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
[[Category:Expressions and Type Conversion]]
+
[[Category:Formatting Functions]]
[[Category:Expressions and Type Conversion Functions]]
+

Revision as of 08:17, 4 February 2013

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;