Operators

In this Topic:

Arithmetic Operators

Operator Description
a + b Add two numeric expressions (number or real).
+ a Return a, which can cause implicit conversion of a to a numeric value.
a - b Subtract a numeric expression from another.
- a Negate the numeric input expression.
a * b Multiply two numeric expressions.
a / b Divide two numeric expressions.
a % b Compute the modulo of numeric expressions a per b.

Comparison Operators

Operator Description
a = b a is equal to b.
a != b a is not equal to b.
a <> b a is less than or greater than b.
a > b a is greater than b.
a >= b a is greater than or equal to b.
a < b a is less than b.
a <= b a is less than or equal to b.

Logical Operators

Logical operators return the result of a particular Boolean operation.

They can only be used as a predicate (e.g. in the WHERE clause). Input expressions must be predicates.

Operator Description
a AND b Matches both inputs.
a OR b Matches either input.
NOT a Does not match the input.