Recipients - Managing customer data > Searching for recipients > Searching for fields > Drop-down list for relational operators

Drop-down list for relational operators

Relational operators define a relation between the field content and the reference value. The OpenEMM supports the following relational operators:

Relational operator

Description

=

Field value and contents are identical. The reference value may be a number or text.
Please note: When using the equals operator, reference value and field contents must be absolutely identical. However, no difference is made between uppercase and lowercase letters: Axel equals axel.

<>

Field contents and reference value are different (unequal). The reference value may be a number or text.

>

The field contents is more than the reference value. The reference value may be a number, a date or text. If it is text, the sequence in the alphabet matters, i.e. b is more than a.

<

The field contents is less than the reference value. The reference value may be a number, a date or text. If it is text, the sequence in the alphabet matters, i.e. a is less than b.

LIKE

The field content is like a reference text containing wildcards.

NOT LIKE

The field content is not like a reference text containing wildcards.

MOD

Modulo operator, see chapter "List split using MOD".

IS

Content check, see chapter "IS and NULL or NOT NULL".

<=

The field contents is less than the reference value or equal. The reference value may be a number, a date or text. If it is text, the sequence in the alphabet matters, i.e. a is less than b.

>=

The field contents is more than the reference value or equal. The reference value may be a number, a date or text. If it is text, the sequence in the alphabet matters, i.e. b is more than a.

Using the relational operators LIKE and NOT LIKE, you can select recipient addresses, for instance searching for similar-sounding names or identical address elements. If you wanted to search for all recipients in your database who use T-Online as their service provider, you could use this operator. Such a search works with so-called wildcards or replacement characters for any other character.

The wildcard character _ (underline character) replaces any single character.
The wildcard character % (per cent character) replaces a string of characters of any length.

If you enter %@t-online.de as the reference value and select the LIKE operator, only recipients whose e-mail address is with T-Online will be listed. Examples would be hans@t-online.de and maurer.krause@t-online.de. If you select NOT LIKE, all recipients who do not have an e-mail address with T-Online will be displayed.