UltraLite Database User's Guide
Dynamic SQL
Dynamic SQL language elements
Operators
The following operators can be used on integer data types in UltraLite.
| Operator | Description |
|---|---|
| & | bitwise AND |
| | | bitwise OR |
| ^ | bitwise exclusive OR |
| ~ | bitwise NOT |
The bitwise operators &, | and ~ are not interchangeable with the logical operators AND, OR, and NOT. The bitwise operators operate on integer values using the bit representation of the values.
For example, the following statement selects rows in which the correct bits are set.
SELECT * FROM tableA WHERE (options & 0x0101) <> 0