Bitwise operators

The following operators can be used on integer data types and bit array data types in SQL Anywhere.

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.

Example

For example, the following statement selects rows in which the correct bits are set.

SELECT *
FROM tableA
WHERE ( options & 0x0101 ) <> 0;