<< Click to Display Table of Contents >> Navigation:  Available Functions > Empty()

Syntax

Empty( <FieldName> )

 

Purpose

To determine whether a field is empty. That is, whether the field has no data in it.

 

Parameters

<FieldName> is the name of a field.

 

Returns

A Logical (true/false) value.

 

Usage

This function is intended to be used to test fields for not having data.

 

Example

You want to know all of the donors who have nothing in their Salutation1 field. This can be accomplished using a Custom selection consisting of a single condition like this:

 

Empty( .Salutation1. )

 

Notice that since the "Empty()" function returns a logical value, it creates a valid selection condition all by itself. After all, that's all selection conditions really are -- just logical (true/false) expressions. You could also ask the opposite question of "who are the donors with data in their salutation field" by simply negating the logical result of "Empty()" like this:

 

.NOT. Empty( .Salutation1. )