Operators by Category

Arithmetic Operators

+ (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.

Conditional Operators

= (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.

Boolean Operators

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.