One or more clauses define the terms for creation of the segment. Each clause is true or false for a member, and can be connected to other clauses by using the AND, OR, NOT, or parentheses.
If member text field
Select the text field from the drop-down menu.
Is
Select the desired command from the drop-down menu.
This value
Enter the value to determine the clause.
Example:
Selecting a text clause of "If member text field domain_ is equal to yahoo.com", will create a segment for all members with a domain name of @yahoo.com. This can be paired with one or more clauses by using AND, OR, NOT, or the parentheses.
Note: Some of the comparison options don't work for all kinds of text fields on different database platforms, so it is very important to test the segment to see if the database raises errors. Generally, the problem, if any, will be that "equals", "less than", and "greater than" are not allowed for some types of fields.
Match Case
If checked, only those results which match the case (upper, lower, or a mixture) exactly will be selected.