An operator performs on separate data items and returns a result. The data items are called operands or arguments. Operators are mentioned by special characters or by keywords.
Operator | Description |
|---|---|
= | Equals (all types). |
< | Less than (number types only). |
> | Greater than (number types only). |
<= | Less than or equal to (number types only). |
>= | Greater than or equal to (number types only). |
<> | Not equal to (all types). |
(not)? like | Compare to a string supporting the % character as a symbol to any string (string types only). |
(not)? between | Check if an identifier is between two values (number types only). |
(not)? in | Check if an identifier is in a list of values (all types). |
(not)? matches | Perform a regular expression match (string types only). |
(not)? contains | Perform a simple and fast string match (string types only). |
length | When inserted before an identifier, indicates a condition on the field's length. For example:
|