You are here:
Operators
Learn about the expression operators that you can use with profile and preference attributes in data extensions.
| Function | Description |
|---|---|
| is equal to | The results include subscribers with an attribute definition that exactly matches the value. You can specify only one value. |
| is not equal to | The results include subscribers with an attribute definition that doesn’t match the value. You can specify only one value. |
|
The results include subscribers with an attribute definition that’s greater than (or greater than or equal to) the specified value. Use these operators only with numeric attributes. |
|
The results include subscribers with an attribute definition less than (or less than or equal to) the value. Use these operators only with numeric attributes. |
| begins with | The results include attribute values that begin with the exact sequence of characters that you specified. Commas are treated as characters and not as delimiters. Search strings aren’t case-sensitive. |
| contains | The results include attribute values that include the specified string. Commas are treated as characters and not as delimiters. Search strings aren’t case-sensitive. |
| does not contain | The results include attribute values that don’t contain the specified string. Commas are treated as characters and not as delimiters. Search strings aren’t case-sensitive. |
| ends with | The results include attribute values that end with the exact sequence of characters that you specified. Commas are treated as characters and not as delimiters. Search strings aren’t case-sensitive. |
| exists in | The results include subscribers with an attribute definition that matches one of
the values you define in a comma-delimited list of values. This operator looks for
a partial match of the entire value. For example, if your match criteria is
north, this operator matches subscribers with attribute
values of |
| exists in whole word | The results include subscribers for which the entire value of the attribute matches one of the values you define. You can specify a comma-delimited list of values. For example, if your match criteria are 2326,5308, this operator returns only subscribers where the entire value of the attribute is 2326 or 5308. |
| does not exist in | The results include subscribers with an attribute definition that doesn’t match any of the specified values. You can specify a comma-delimited string of values. This operator isn’t applicable when you choose an attribute that has restricted values, because you can select only one of the restricted values as the comparison value. Search strings aren’t case-sensitive. |
| is empty | The results include subscribers for which the specified field doesn’t contain any content. |
| is not empty | The results include subscribers for which the specified field contains content (that is, the value of the field isn't blank). |
| is | The results include subscribers that have a true or false value for the specified attribute. |
