Selection Criteria

There are 5 sets of drop-down selection boxes and input fields that allow you to build the where clause of the subset more easily. The first column selects which field will be compared. Only fields in the member table will be displayed. The second field selects what the comparison criterion will be and the third field allows the user to enter the value that will be compared. No quoting is required in this field. The SQL column type is displayed in parentheses after each column name.

For example, let's say your members table has a pets column, and you'd like to send to all the cat owners. The comparison criterion would be:

pets = cat

On the other hand, if you'd like to send to everyone who is not a cat owner, your comparison criterion would be:

pets <> cat