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

SQL Anywhere 11.0.1 » UltraLite - Database Management and Reference » UltraLite SQL Reference » UltraLite SQL elements » Operators in UltraLite

 

Bitwise operators

Bitwise operators perform bit manipulations between two expressions. The following operators can be used on integer data types in UltraLite.

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. The bitwise operators operate on integer values using the bit representation of the values.

Example

The following statement selects rows in which the specified bits are set.

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