Comparison operators
<< Symbols and brackets used in code syntax | SQL Language Reference | Firebird SQL >>
Comparison operators
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 |
See also:
Conditional test
Operator
NULL in operations
back to top of page
<< Symbols and brackets used in code syntax | SQL Language Reference | Firebird SQL >>
