Operator Precedence

The larger the number, the higher the precedence. Operators with equal precedence are grouped left to right unless parentheses are used.

Precedence Operator Description
14 a[n] Subscript
14 f() Function call
13 PREV/TOT Modifiers
12 CHARTONR DATETONR NRTODATE Conversion operators
11 YEAR MONTH DAY
HOUR MINUTE SEC HUNDREDTH
Extraction
10 SUM Multi-occurs operator
10 CONCAT  
10 SETYEAR SETMONTH SETDAY
SETHOUR SETMINUTE SETSECOND SETHUNDREDTH  
Date/Time Operators
10 UPPERCASE Character operator
9 - Unary Minus
9 ABS Absolute Value
9 ~ Bitwise Complement
8 * / Multiplication/Division
8 MOD Remainder after division
8 & Bitwise and
7 IN Test occurrences
7 + - Addition/Subtraction
7 XOR ^ Bitwise XOR
7 ! Bitwise OR
6 < > <= >= Relational
5 = == <> != Equal/not equal
4 NOT Logical/bitwise operator
3 AND Logical/Bitwise operator
2 OR Logical/Bitwise operator
1 PROVIDED SIGNEDON Numeric/Logical Binary operators