Expression Operators
Concatenation is supported within expressions using Boolean AND, OR, and NOT operators. You can use parentheses to group clauses and force precedence. The AND operator has precedence over other operators. Example: (LastName = 'Smith' OR LastName = 'Jones') AND FirstName = 'John'
When you create comparison expressions, the following operators are allowed:
< | > | <= | >= | <> |
= | IN | LIKE |
When you create comparison arithmetic expressions, the following operators are allowed:
+ (addition) | - (subtraction) | * (multiplication) | / (division) | % (modulus) |