Operators defined
Operator | Description |
|---|---|
NOT EQUAL TO (!=) | Determines whether the element or math expression isn't equal to the value (a constant, element or math expression). |
LESS THAN (<) | Determines whether the element or math expression is less than the value (a constant, element or math expression). |
LESS OR EQUAL TO (<) | Determines whether the element or math expression is less than or equal to the value (a constant, element or math expression). |
EQUAL TO (=) | Determines whether the element or math expression is equal to value (a constant, element or math expression). |
GREATER THAN (>) | Determines whether the element or math expression is greater than the value (a constant, element or math expression). |
GREATER OR EQUAL TO (>=) | Determines whether the element or math expression is greater than or equal to the value (a constant, element or math expression). |
IS EU | Determines whether a country's an EU member. |
IS GCC | Determines whether a country's a Gulf Cooperation Council (GCC) member state. |
IS NOT EU | Determines whether a country isn't an EU member state. |
IS NOT GCC | Determines whether a country isn't a GCC member state. |
IS NOT NULL | Determines whether an element contains a value. |
LIKE NOT LIKE | Use for string elements. The LIKE and NOT LIKE operators use wildcard characters to perform string pattern matching. The % (percent) character matches any number of characters. The _ (underscore) character matches a single character. |
EXISTS IN NOT EXISTS IN | Use for lookup lists. The EXISTS IN operator determines whether the value contained in the element's contained in the specified lookup list. The NOT EXISTS IN operator determines whether the value contained in the element isn't contained in the specified lookup list. |