Relational Operators

The relational operators are used to compare expressions.

Evaluation Rules for Relational Operators

The following table defines the evaluation rules for relational operators. The rules assume that the data types of the expressions can be compared. For a complete overview of comparable data types, refer to the next section, "Valid Uses of Relational Operators".

Operator Operator name Expression Resulting date type
> Greater than Expr > Expr Boolean
< Less than Expr < Expr Boolean
>= Greater than or equal Expr >= Expr Boolean
<= Less than or equal Expr <= Expr Boolean
<> Not equal to Expr <> Expr Boolean
= Equal to Expr = Expr Boolean
IN In range Expr IN [Valueset] Boolean


When using relational operators, uppercase and lowercase letters in strings are significant. Furthermore, the comparison is based on the built-in character comparison table of the system, that is, not by comparing "true" ASCII characters.

Valid Uses of Relational Operators

The following table describes the valid uses of the relational operators and the data types that result when expressions are evaluated. The invalid combinations of types for relational operators are indicated by a dash. All relational operators are binary infix operators; that is, they take a left and a right argument and are placed between the arguments.

The rows in the table show the type of the left argument and the columns show the type of the right argument. The cells show the resulting data type.

A valid use of the relational operators is, for example, text compared with text or code, while Boolean cannot be compared with anything other than Boolean, and so on.

Relational operator Boolean Char Option Integer Decimal Date Time Text Code
Boolean Boolean
char Boolean Boolean Boolean Boolean
option Boolean Boolean Boolean Boolean
integer Boolean Boolean Boolean Boolean
decimal Boolean Boolean Boolean Boolean
date Boolean
time Boolean
text Boolean Boolean
code Boolean Boolean

See Also

Type Conversion