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

SQL Anywhere 11.0.1 (Français) » 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.

Example

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

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