Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
The following operators can be used on integer data types and bit array data types in SQL Anywhere.
|^||bitwise exclusive OR|
The bitwise operators &, | and ~ are not interchangeable with the logical operators AND, OR, and NOT.
For example, the following statement selects rows in which the correct bits are set.
SELECT * FROM tableA WHERE (options & 0x0101) <> 0