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.
operator | Data type | explanation | ||||
---|---|---|---|---|---|---|
string | Numerical value | date | logic | Expression | ||
be equivalent to | The condition is true if the first value is equal to the second value. | |||||
not equal | The 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. |