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. |
<> |
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.