Field

This allows you to select one of the Contact fields to perform a match against.

Operator

The Operator list allows you to select one how the value and field will be matched.

Value

The value text box allows you to enter the value that you would like to match on.

=

True when the Contact Field is equal to the specified value.

Use the (ignore case) option when you want the match to be case insensitive.

<>

True when the Contact Field is not equal to the specified value.

Use the (ignore case) option when you want the match to be case insensitive.

>

True when the Contact Field is greater than the specified value.

This operator applies only to numeric and date fields. When used with text fields it performs a case sensitive pattern match which can be more reliably performed using begins with.

>=

True when the Contact Field is greater than or equal to the specified value.

This operator applies only to numeric and date fields. When used with text fields it performs a case sensitive pattern match which can be more reliably performed using begins with.

<

True when the Contact Field is less than the specified value.

This operator applies only to numeric and date fields. When used with text fields it performs a case sensitive pattern match which can be more reliably performed using begins with.

<=

True when the Contact Field is less than or equal to the specified value.

This operator applies only to numeric and date fields. When used with text fields it performs a case sensitive pattern match which can be more reliably performed using begins with.

is one of

True when the Contact Field is one of the values in the value list.

To specify a value list, enter each value into the Value text box, separated by a comma or space.

Use the (ignore case) option when you want the match to be case insensitive.

is not one of

True when the Contact Field is not one of the values in the value list.

To specify a value list, enter each value into the Value text box, separated by a comma or space.

Use the (ignore case) option when you want the match to be case insensitive.

contains

True when the Contact Field contains the value.

For example, a value of Jan would match Jan, Jane and Mary-Jane.

Use the (ignore case) option when you want the match to be case insensitive.

does not contain

True when the Contact Field does not contains the value.

Use the (ignore case) option when you want the match to be case insensitive.

starts with

True when the Contact Field begins with the Value.

For example a value of New will match both New York and New Orleans.

Use the (ignore case) option when you want the match to be case insensitive.

does not start with

True when the Contact Field does not begin with the Value.

Use the (ignore case) option when you want the match to be case insensitive.

ends with

True when the Contact Field ends with the Value.

For example a value of Dakota will match both North Dakota and South Dakota.

Use the (ignore case) option when you want the match to be case insensitive.

not ends with

True when the Contact Field does not end with the Value.

Use the (ignore case) option when you want the match to be case insensitive.

is null

True when the Contact Field has no value (not even a blank value).

For most purposes use is blank to check to an empty field.

is not null

True when the Contact Field has a value (even a blank value).

is blank

True when the Contact Field has no value or when a numeric field has a value of 0.

is not blank

True when the Contact Field has a value and if it is a numeric field that value is not 0.