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. |