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.