Compares two expressions and returns a value of "true" or "false".
expression1 | = < <= <> > >= |
expression2 |
expression1 | any value expression |
expression2 | any value expression |
Logical
In a conditional expression, the less than sign (<) compares the expressions to its left and right, and is logically true if the expression on the left is "smaller" than the expression on the right; otherwise, it is logically false.
In a conditional expression, the less than or equals sign (<=) compares the expressions to its left and right, and is logically true if the expression on the left is "smaller" than or equal to the expression on the right; otherwise, it is logically false.
In a conditional expression, the not equals sign (<>) compares the expressions to its left and right, and is logically true if they are not equal; otherwise, it is logically false.
In a conditional expression, the equals sign (=) compares the expressions to its left and right, and is logically true if they are equal; otherwise, it is logically false.
In a conditional expression, the greater than sign (>) compares the expressions to its left and right, and is logically true if the expression on the left is "larger" than the expression on the right; otherwise, it is logically false.
In a conditional expression, the greater than or equals sign (>=) compares the expressions to its left and right, and is logically true if the expression on the left is "larger" than or equal to the expression on the right; otherwise, it is logically false.
Examples
case
when GeoLocation = "New York"
... commands ...
otherwise
... more commands ...
endcase
while var1 < 11
... commands ...
var1 = var1 + 1
endwhile
DayCare = {"subsidized" where GIncome <= 22000, "not subsidized"}
case
when GeoLocation <> "Madrid"
... commands ...
otherwise
... more commands ...
endcase
case
when GoodsValue > 2000
... commands ...
otherwise
... more commands ...
endcase
case
when Age >= 65
... commands ...
otherwise
... more commands ...
endcase