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.

Related Content