613-518-1166 info@zimdatabases.com
Select Page

# =, <, <=, <>, >, >= (Condition)

Compares two expressions and returns a value of “true” or “false”.

### Syntax

 expression1 =<<=<>>>= expression2

### Parameters

 expression1 any value expression expression2 any value expression

Logical

### Comments

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

See Also

About Conditional Expressions

About Data Types

Was this article helpful?
###### 0 out Of 5 Stars
 5 Stars 0% 4 Stars 0% 3 Stars 0% 2 Stars 0% 1 Stars 0%
##### How can we improve this article?
Table of Contents