The following Boolean operators can be used in an expression.
The syntax is operand1 operator operand2 or operator operand.
logical and (valid for two Boolean operands)
logical or (valid for two Boolean operands)
logical not (valid for one Boolean operand)
The following arithmetic operators can be used in an expression.
The syntax is operand1 operator operand2 or operator operand.
add (valid for two numeric operands)
subtract (valid for one or two numeric operands)
multiply (valid for two numeric operands)
divide (valid for two numeric operands)
remainder (valid for two numeric operands)
The following equality or inequality operators can be used in an expression.
The syntax is operand1 operator operand2.
equal to (valid for two numeric, Boolean, or text operands)
not equal to (valid for two numeric, Boolean, or text operands)
less than (valid for two numeric operands)
greater than (valid for two numeric operands)
less than or equal to (valid for two numeric operands)
greater than or equal to (valid for two numeric operands)