Difference between revisions of "ISNULL()"

Revision as of 07:15, 13 June 2018

Purpose

Function to test if an expression evaluates to NULL and optionally specify an alternative value for a null expression

Syntax

ISNULL(<expr1> [, <expr2>])

See Also

COALESCE(), EMPTY(), IFNULL(), ISALPHA(), ISBLANK(), ISDIGIT(), NVL(), SET NULL, SET NULLDISPLAY

Description

The ISNULL() function evaluates the expression in <expr1>, and returns true (.T.) if the expression evaluates to NULL, otherwise false (.F.). If the optional <expr2> is specified, ISNULL() returns the first non-null value: if <expr1> does not evaluate to NULL, the evaluated result is returned, otherwise <expr2> is evaluated and if it does not evaluate to NULL, its evaluated result is returned. If both <expr1> and <expr2> evaluate to NULL, the ISNULL() function returns NULL.

Example

set null on
CREATE TABLE nullon (firstname c(20), lastname c(20))
INSERT INTO nullon (lastname) VALUES ("Smith")
SELECT lastname, isnull(firstname,"Unknown") from nullon
SELECT lastname, isnull(firstname) from nullon
 
// Check for existence of dynamic array / object member
declare da[]
da.name = "Lianja Inc"
? isnull(da["name"])      // .T.
? isnull(da["address"])   // .F.