Tests for a null value. Returns true only if a value is a single text value that is null, otherwise it returns false. This function also returns false if the value is an error.

Note This @function is new with Release 6.

Syntax

@IsNull( value )

Parameters

value

Any data type. Any value.

flag

Boolean
• Returns 1 (True) if the value is a text value that is null
• Returns 0 (False) if the value is not a text value, not null, or is an error

This function is useful for checking for empty fields before using them in other functions in which they might generate errors.

Example

Glossary