Operator Precedence
The following table contains the precedence which the SQL Server uses to evaluate multiple operators in an expression. Based on the rankings, operators with a higher rank are evaluated first before evaluating operators with a lower rank. If an expression consists of multiple operators with the same precedence rank, then the operators are evaluated from left to right.
Rank Operator
1 ~ (Bitwise NOT)
2 * (Multiply), / (Division), % (Modulo)
3 + (Positive), - (Negative), + (Add), (+ Concatenate), - (Subtract), & (Bitwise AND), ^ (Bitwise Exclusive OR), | (Bitwise OR)
4 =, >, <,>=, <=, <>, !=, !>, !< (Comparison operators)
5 NOT
6 AND
7 ALL, ANY, BETWEEN, IN, LIKE, OR, SOME