Operator Evaluation Order
Operator
|
Strength
|
Example
|
- (negation) NOT
|
Max.
|
f = - g ^ 2 is the same as ( - g ) ^ 2
|
IS
|
11
|
|
&
|
9
|
|
&/
|
8
|
|
^
|
7
|
i = 4 ^ 2 * 3 ^ 3 is the same as (4 ^ 2) * ( 3 ^ 3 )
|
* / \ DIV % MOD
|
6
|
i = 4 * 2 + 3 * 3 is the same as (4 * 2) + ( 3 * 3 )
|
+ -
|
5
|
|
= <> >= <= > < LIKE MATCH BEGINS ENDS
|
4
|
i = 4 + 2 = 5 + 1 is the same as ( 4 + 2 ) = ( 5 + 1 )
|
AND OR XOR
|
2
|
i = a > 10 AND a < 20 is the same as ( a > 10 ) AND ( a < 20 )
|
The stronger the operator, the earlier it is evaluated.
If in doubt, rather use brackets to group sub-expressions.