Previous Topic: RelationalExpressionNext Topic: Operands


Operators

A relational operator can be any of the following:

=

EQ

EQUAL

 

 

¬=

NE

NOT EQUAL

NOT=

 

>

GT

GREATER [THAN]

 

 

>=

GE

NOT LESS

NOT<

¬<

<

LT

LESS [THAN]

 

 

<=

LE

NOT GREATER

NOT>

¬>

CONTAINS

NOT CONTAINS

 

 

 

For all of the relational operators, the symbol ¬ can replace NOT, = or EQ can replace EQUAL, > or GT can replace GREATER, and you can use < or LT LESS. The reserved word THAN after GREATER or LESS is optional. You can add it for clarity. You can add the reserved word IS before any operator for clarity.