UltraLite Database User's Guide
Dynamic SQL
Dynamic SQL language elements
Operators
The syntax for binary comparison conditions is as follows:
expression compare expression
where compare is a comparison operator. The following comparison operators are available:
| Operator | Description |
|---|---|
| = | Equal to |
| [ NOT ] LIKE | A text comparison, possibly using regular expressions |
| > | Greater than |
| < | Less than |
| >= | Greater than or equal to |
| <= | Less than or equal to |
| != | Not equal to |
| <> | Not equal to |
| !> | Not greater than |
| !< | Not less than |
Case sensitivity Comparisons are carried out with the same attention to case as the database on which they are operating. By default, UltraLite databases are created as case insensitive.
NULL operators Comparisons involving NULL expressions follow these rules:
Two null values compare as equals. When exactly one of the operands being compared is NULL, the result is UNKNOWN. Thus, SQL comparisons produce one of three results (TRUE, FALSE, and UNKNOWN). Similarly, logical expressions (AND, OR, NOT) can also produce these results.