Operators are the factors that decide whether or not a
condition evaluates as true. Each data type will only have the operators appropriate to its circumstances.
| Data
Types | | ||||
Operator | Expression | Logic | Date | Numerical | String | Description |
Ending
With | | | | | ✔ | If the value being checked ends with
the value being checked against, the condition is true. |
Beginning
With | | | | | ✔ | If the value being checked begins with
the value being checked against, the condition is true. |
Not
Containing | | | | | ✔ | If the value being checked does not
contain the value being checked against, the condition is true. |
Containing | | | | | ✔ | If the value being checked contains the
second value, the condition is true. |
Less
than or Equal to | ✔ | | ✔ | ✔ | | If the value being checked is less than
or equal to the value being checked against, the condition is true. |
Less
Than | ✔ | | ✔ | ✔ | | If the value being checked is less than
the value being checked against, the condition is true. |
Greater
Than or Equal to | ✔ | | ✔ | ✔ | | If the value being checked is greater
than or equal to the value being checked against, the condition is true. |
Greater
Than | ✔ | | ✔ | ✔ | | If the value being checked is greater,
then the condition is true. |
Not
Between | ✔ | | ✔ | ✔ | | If the value being checked is not in
the range entered, the condition is true. |
Between | ✔ | | ✔ | ✔ | | If the value being checked is in the
range entered, the condition is true. |
Not
Equal to | ✔ | ✔ | ✔ | ✔ | ✔ | If the compared values are not equal,
the condition is true. |
Equal
to | ✔ | ✔ | ✔ | ✔ | ✔ | If the compared values are equal, the
condition is true. |