Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Reference » Using SQL » SQL language elements » Operators


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.


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

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