Operators let you define the circumstances under which a condition is considered true. The available operators depend on the data type being operated on, so only the appropriate operators are available. For example, a logical condition can only be true or false, so it cannot be greater than what makes the greater-than operator inappropriate for its data type.

operatorData typeexplanation
stringNumerical valuedatelogicExpression
be equivalent toThe condition is true if the first value is equal to the second value. 
not equalThe condition is true if the first value is not equal to the second value. 
Between  The condition is true if the first value is within the range. 
not between  The condition is true if the first value is not in the range. 
Greater  The condition is true if the first value is greater than the second value. 
that's all  The condition is true if the first value is greater than the second value equal to the second value. 
Less than  The condition is true if the first value is less than the second value. 
below or below  The condition is true if the first value is less than or equal to the second value. 
include    The condition is true if the first value contains the second value. This operator is used only for strings. 
Not included    The condition is true if the first value does not contain the second value. This operator is used only for strings. 
starts with    The condition is true if the first value starts with the second value. This operator is used only for strings. 
end with    The condition is true if the first value ends with the second value. This operator is used only for strings.