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