+ (Add/Positive) indicates a positive value (unary +) or adds two values.
- (Subtract/Negative) indicates a negative value (unary -) or subtracts one value from another.
* (Multiply) multiplies one value by another.
/ (Divide) divides one value by another.
^ (Exponent) raises one value to the power of another.
() (Parentheses) change the order in which arithmetic operators are executed.
= (Equals) compares two values and returns a true/false result.
<> (Not equals) compares two values and returns a true/false result.
< (Less than) compares two values and returns a true/false result.
> (Greater than) compares two values and returns a true/false result.
<= (Less than or equals) compares two values and returns a true/false result.
>= (Greater than or equals) compares two values and returns a true/false result.
[NOT] BETWEEN compares one value to two others and returns a true/false result.
[NOT] IN compares one value to a list of values and returns a true/false result.
IS [NOT] [$]NULL indicates whether a value is $Null and returns a true/false result.
[NOT] LIKE compares a value to a pattern and returns a true/false result.
WHERE controls the evaluation of other expressions.
( ) (Parentheses) groups expressions, altering the order of evaluation.
NOT performs a Boolean NOT of a logic expression.
AND performs a Boolean AND of two logic expressions.
OR performs a Boolean OR of two logic expressions.
XOR performs a Boolean XOR (exclusive OR) of two logic expressions.
( ) (Parentheses) groups expressions, altering the order of evaluation.