Precedence order for operators and functions
The operators and functions in an expression perform in a prescribed order.
Operations of equal order perform from left to right. This table lists the order for
specific operators.
TIP:
When an expression contains multiple
operators or functions, group the conditions in parentheses. This ensures the
correct order of execution, and makes it easier to read the expression.
Order | Operation |
|---|---|
1 | ( ) |
2 | function (such as ABS, ACOS, ASIN, ATAN, COS, DEG, BCD_TO,
LN, LOG, RAD, SIN, SQRT, TAN, TO_BCD, TRUNC) |
3 | ** |
4 | - (negate), NOT, ! |
5 | *, /, MOD |
6 | - (subtract), + |
7 | AND, & |
8 | XOR |
9 | OR |
10 | <, <=, >, >=, =, <> |
11 | && |
12 | ^^ |
13 | || |
Provide Feedback