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. |