Difference between revisions of "ISNULL()"

From Lianjapedia
Jump to: navigation, search
 
m (1 revision)
(No difference)

Revision as of 05:56, 25 October 2011

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