Comparison operators
Comparison operators allow you to compare two values, to include the greater than, less than and equal to functions.
| Operator | Description |
|---|---|
| IS NULL | The IS NULL operator
checks for NULL values. |
| LIKE | The LIKE operator
returns TRUE if a string matches a given mask. |
| MATCHES | The MATCHES operator
returns TRUE if a string matches a given mask. |
| Equal to (== or =) | The == operator checks for equality of two
expressions or for two record variables. A single = can be used as alias for
==. |
| Different from (!= or <>) | The != operator checks for
non-equality of two expressions or for two record variables. The <> can be used
as alias for !=. |
| Lower (<) | The < operator
is provided to test whether a value or expression is lower than another. |
| Lower or equal (<=) | The <= operator
is provided to test whether a value or expression is lower than or
equal to another. |
| Greater (>) | The > operator
is provided to test whether a value or expression is greater than
another. |
| Greater or equal (>=) | The >= operator
is provided to test whether a value or expression is greater than
or equal to another. |
| NVL() | The NVL() operator
returns the second parameter if the first argument evaluates to NULL. |
| IIF() | The IIF() operator
returns the second or third parameter depending on the boolean expression
given as first argument. |