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.