Appendix: Logical Operators

1. Is
2. Is not
3. Is equal to
4. Is not equal to
5. Is greater than
6. Is greater than or equal to
7. Is less than
8. Is less than or equal to
9. Exists in
10. Exists in whole word
11. Does not exist in
12. Begins with
13. Ends with
14. Contains
15. Does not contain
16. Is anniversary of
17. Is not anniversary of
18. Is after
19. Is after anniversary of
20. Is before
21. Is before anniversary of

When you create the profile attributes for your subscribers, you select the data type--Text, Numeric, or Date--to specify the kind of data that is stored in the field. The data type of the profile attribute that you select for the filter condition determines the operators that you can choose. The operators are used in the data filter and measures features.

The following table contains the operators for each data type:

Name	Constrained List	Text	Numeric	Date
is	x
is not	x
is equal to		x	x	x
is not equal to		x	x	x
is greater than		x	x
is greater than or equal to		x	x
is less than		x	x
is less than or equal to		x	x
exists in		x
exists in whole word		x
does not exist in		x
begins with		x
ends with		x
contains		x
does not contain		x
is anniversary of				x
is not anniversary of				x
is after				x
is after anniversary of				x
is before				x
is before anniversary of				x

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.