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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Language Elements » Operators

String operators Next Page

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