These operators are used to compare the values of the operands
and determine the relation
present among them. Let us assume that variable X is equal to 1 and that variable Y is
equal to 2.
Operators
Definition
Examples
<=
The condition is only true if the left operand’s value is less than or
equivalent to the right operand’s value.
(X <= Y) is true.
>=
The condition is only true if the left operand’s
value is great than or equal
to the right operand’s value.
(Y >= X) is true.
<>
The condition is only true if the values of the two operands are unequal.
(X <> Y) is true.
<
The condition is only true if the value of the right operand is greater than
the value of the left operand.
(X < Y) is true.
>
The condition is only true if the value of the right
operand is lesser than the
value of the left operand.
(X > Y) is not true.
==
The condition is only true if the values of the operands are equal.
(X == Y) is not true.
!=
The condition is only true if the values of the operands are not equal.
This one is similar to <> above.