Comparison Predicates
Purpose
Comparison predicates compare two expressions and return whether the comparison is true.
Syntax
Usage Notes
The following tables lists the comparison predicates you can use:
Predicates | Description |
---|---|
= | Equality check |
!= | Inequality check (the aliases <> and ^= also exist for this) |
< | Check for "less than" |
<= | Check for "less than or equal to" |
> | Check for "more than" |
>= | Check for "more than or equal to" |
- If one of the two expressions is a NULL value, the result is also a NULL value.