The following operators (shown in decreasing order of precedence) can be used when building an expression. Operators of equal precedence are evaluated from left to right.
Operator |
Description |
() |
Function calls and parentheses |
- |
Unary minus (as in -14) |
^ |
Exponentiation |
*/+ |
Multiply, divide and add character concatenation |
+ - |
Add and subtract |
> |
Greater than (see note) |
< |
Less than (see note) |
= |
Equal (see note) |
>= |
Greater than or equal (see note) |
<= |
Less than or equal (see note) |
<> |
Not equal (see note) |
NOT |
Logical NOT |
AND or & |
Logical AND |
OR or | |
Logical OR |
Note: All greater than, less than, equal and not equal operators have equal precedence.