Appendix: Logical Operators

Is

Subscribers with an attribute value that matches this value will satisfy the condition. This operator is only available when the valid values for the attribute are constrained by a list.

Is not

Subscribers with an attribute value that does not match this value will satisfy the condition. This operator is only available when the valid values for the attribute are constrained by a list.

Is equal to

Subscriber with an attribute value that exactly matches the value will satisfy the condition.

Is not equal to

Subscribers with an attribute value that does not exactly match the value will satisfy the condition.

Is greater than

Subscribers with an attribute value that is greater than the value will satisfy the condition.

Is greater than or equal to

Subscribers with an attribute value that is greater than or equal to the value will satisfy the condition.

Is less than

Subscribers with an attribute value that is less than the value will satisfy the condition.

Is less than or equal to

Subscribers with an attribute value that is less than or equal to the value will satisfy the condition.

Exists in

Subscribers with an attribute value that matches any part of one of the values you define in a comma-delimited string of values will satisfy the condition.

Like partial text searches (such as begins with and ends with), the Exists In operator looks for a partial match of the entire value.

For example, if your match criteria is north, the Exists In operator is satisfied by subscribers with the following attribute values:

• north
• northwest
• northeast

The operator is not satisfied by subscribers with south, southwest, and southeast attribute values.

Exists in whole word

Subscribers with an attribute value that matches one of the values you define in a comma-delimited string of values will satisfy the condition.

Unlike the Exists In operator, the Exists In Whole Word operator requires the match be a whole word. For example, if your match criteria is north, the Exists In whole word operator is satisfied by subscribers with north, but not subscribers with northwest or northeast attribute values.

Does not exist in

Subscribers with an attribute value that do not match any of the values you define in a comma delimited string of values will satisfy the condition.

Like partial text searches (such as begins with and ends with), the Does Not Exist In operator looks for a partial match of the entire value. For example, if your match criteria is north, the Does Not Exist In operator returns subscribers with south, southwest, and southeast attribute values, but not subscribers with north, northwest, and northeast attribute values.

Begins with

Subscribers with an attribute value that begins with the exact sequence of characters that you enter as the criteria value will satisfy the condition. Commas are treated as characters and not as delimiters.

Ends with

Subscribers with an attribute value that ends with the exact sequence of characters that you enter as the criteria value will satisfy the condition. Commas are treated as characters and not as delimiters.

Contains

Subscribers with an attribute value that includes the exact sequence of characters that you enter as the comparison value will satisfy the condition. Commas are treated as characters and not as delimiters.

Does not contain

Subscribers with an attribute value that excludes the exact sequence of characters that you enter as the criteria value will satisfy the condition. Commas are treated as characters and not as delimiters.

Is anniversary of

Used only with date fields. Subscribers with an attribute value that matches the criteria value (the system ignores the year) will satisfy the condition. This operator functions only with data filters.

Is not anniversary of

Used only with date fields. Subscribers with an attribute value that does not match the criteria value (the system ignores the year) will satisfy the condition. This operator functions only with data filters.

Is after

Used only with date fields. Subscribers with an attribute value that occurs after the criteria value will satisfy the condition.

Is after anniversary of

Used only with date fields. Subscribers with an attribute value that occurs after the criteria value (the system ignores the year) will satisfy the condition. This operator functions only with data filters.

Is before

Used only with date fields. Subscriber with an attribute value that occurs before the criteria value will satisfy the condition.

Is before anniversary of

Used only with date fields. Subscribers with an attribute value that occurs before the criteria value (the system ignores the year) will satisfy the condition. This operator functions only with data filters.