Synonyms are listed in groups. The table shows the syntax for the first operator, but operators that are synonyms follow the same syntax rules.
Operators
| Operator | Syntax |
| Arithmetic operators | |
* | number * number |
| + | number + number date + number |
| - | number - number date - number date - date |
� / | number ( � | / ) number |
| ^ | number ^ number |
| div | number div number |
| mod | number mod number |
| Logical operators | |
| and | Boolean and Boolean |
| not | not Boolean |
| or | Boolean or Boolean |
| Containment operators | |
start[s] with begin[s] with | list starts with list string starts with string |
| end[s] with | list ends with list string ends with string |
| contains | list contains list record contains record string contains string |
does not contain doesn't contain | list does not contain list record does not contain record string does not contain string |
| |
is in is contained by | list is in list record is in record string is in string |
is not in is not contained by isn't contained by | list is not in list record is not in record string is not in string |
| Comparison operators (equality and inequality) |
= equal equals equal to is is equal to | expression = expression |
�
does not equal doesn't equal
is not is not equal [to] isn't isn't equal [to] | expression � expression |
| Comparison operators (precedence) | |
< comes before
is less than is not greater than or equal [to] isn't greater than or equal [to] less than | date < date integer < integer real < real string < string |
> comes after
greater than is greater than is not less than or equal [to] isn't less than or equal [to] | date > date integer > integer real > real string > string |
| |
� <= does not come after doesn't come after is less than or equal [to] is not greater than isn't greater than less than or equal [to] | date � date integer � integer real � real string � string |
� >= does not come before doesn't come before greater than or equal [to] is greater than or equal [to] is not less than isn't less than | date � date integer � integer real � real string � string |
| Miscellaneous operators | |
| & | expression & expression |
| as | expression as className |
| a reference to | [a] ( ref [to] | reference to ) ÿ reference |