Comparison operators for use in conditional clauses:
| Conditional Test | Description |
|---|---|
| value = value | Equal to |
| value < value | Less than |
| value > value | Greater than |
| value ⇐ value | Less than or equal to |
| value >= value | Greater than or equal to |
| value !< value | Not less than |
| value !> value | Not greater than |
| value <> value | Not equal to |
| value != value | Not equal to |
| value LIKE value | Wildcard search, use '%' for 0 or more characters and '_' for one character only |
| value BETWEEN value AND value | Within an inclusive range |
| value IN (value, … value) | One of the elements in a list |
| value IS NULL | One of the elements in a list |
| value IS NOT NULL | One of the elements in a list |
| value CONTAINING value | Includes |
| value STARTING WITH value | Begins with |