Operators

Operators enable you to define the circumstances in which a condition is deemed to be true. The operators available depend on the data type being operated upon, so only the appropriate operators will be available. For example, a logical condition can only be true or false, so it cannot be greater than anything making the greater than operator inappropriate for that data type.

The table below shows a list of operators and the data with which they can be used:

Operator	Types of data					Description
Operator	String	Numerical	Date	Logic	Expression	Description
equal to						If the first value is equal to the second, then the condition is true.
not equal to						If the first value is not equal to the second, then the condition is true.
between						If the first value is in the range, then the condition is true.
not between						If the first value is not in the range, then the condition is true.
greater than						If the first value is greater then the second value, then the condition is true.
greater than or equal to						If the first value is greater then the second value of equal to the second value, then the condition is true.
less than						If the first value is less then the second value, then the condition is true.
less then or equal to						If the first value is less then the second value or equal to the second value, then the condition is true.
containing						If the first value contains the second value, then the condition is true. This operator is used only for strings.
not containing						If the first value does not contain the second value, then the condition is true. This operator is used only for strings.
beginning with						If the first value starts with the second value, then the condition is true. This operatior is used only for strings.
ending with						If the first value ends with the second value, then the condition is true. This operator is used only for strings.