There are standard functions built in for comparing equality, inequality etc.
Name | Symbol | Alternative | Example |
---|---|---|---|
Equal | = | EQ | i = j |
Not equal | <> | NE | i <> j |
Less than | < | LT | i < j |
less than or equal | <= | LE | i <= j |
Greater than | >= | GT | i > j |
Greater than or equal | ≥= | GE | i >= j |
The symbol can be exchanged with the alternative and vice versa. So var1 <> var2
is the same thing as var1 NE var2
.
You can compare a float with an integer but you cannot compare for instance a date with an integer.