Operators

An operator is used to specify the way in which two operands are to be combined or compared. All valid operators that can be used in an expression are described in the following table:

Related topic

Expression syntax

Operation and operator	Action	Result
Assignment Operator
operand2 := operand1	Assignment	operand1
Boolean Operators
operand1 AND operand2	Logical AND	Boolean
operand1 OR operand2	Logical OR	Boolean
NOT operand1	Logical negation	Boolean
Comparison Operators
operand1 EQ operand2	Equal to	Boolean
operand1 NE operand2	Not equal to	Boolean
operand1 GT operand2	Greater than	Boolean
operand1 LT operand2	Less than	Boolean
operand1 GE operand2	Greater than or equal to	Boolean
operand1 LE operand2	Less than or equal to	Boolean
operand1 == operand2	Equal to	Boolean
operand1 <> operand2	Not equal to	Boolean
operand1 > operand2	Greater than	Boolean
operand1 < operand2	Less than	Boolean
operand1 >= operand2	Greater than or equal to	Boolean
operand1 <= operand2	Less than or equal to	Boolean
Numeric Operators
operand1 + operand2	Addition	Sum
operand1 - operand2	Subtraction	Difference
operand1 * operand2	Multiplication	Product
operand1 / operand2	Division	Quotient
Conditional Operator
operand1 THEN operand2 ELSE operand3	Conditional selection	operand2 or operand3

This section contains the following topics:

Operators

Comments