ASA SQL Reference
SQL Language Elements
Operators
The precedence of operators in expressions is as follows. The operators at the top of the list are evaluated before those at the bottom of the list.
unary operators (operators that require a single operand)
&, | , ^, ~
*, /, %
+, -
||
not
and
or
When you use more than one operator in an expression, it is recommended that you make the order of operation explicit using parentheses rather than relying on an identical operator precedence between Adaptive Server Enterprise and Adaptive Server Anywhere.