Function: IsBlank

Description

Returns 1 if string is empty or contains only spaces, otherwise returns 0 (zero).

Syntax

IsBlank(string)

Arguments

string can be a character field, an expression that results in a string or a function that returns a string.

Return value

This function returns a number: 1 if the field is empty, 0 if the field contains data.

Calculated field example

If the Amount field contained no value, or just spaces, the following calculated field expression would return a 1 (indicating that the field is empty): IsBlank(Amount)

Filter/Find example

Records with a blank Amount field can be selected or found using the expression: IsBlank(Amount)=1