Using relational operators in the advanced search bar

Relational operators are useful especially in non-text fields (such as date and time fields) when you want to search for a value within a numerical range.

You can use the following relational operators only in the advanced search bar. You cannot use them in a form. See Using relational operators in a search.

Operators

Order of precedence for multiple operators

When you use multiple operators to construct qualification criteria, they are executed in the following order of precedence:

1. ( )
2. NOT (!) - (unary minus)
3. ** / %*
4. + -
5. < <= > >= = != LIKE
6. AND (&&)
7. OR (||)

If the qualification contains multiple operators of the same precedence value, they are executed in the order that they occur (from left to right). For example, in the expression A + (B*C), the multiplication takes first precedence because it occurs within parentheses, which are of a higher precedence than addition.