Contents Index String operators Join operators

ASA SQL Reference
  SQL Language Elements
    Operators

Bitwise operators


The following operators can be used on integer data types, in both Adaptive Server Anywhere and Adaptive Server Enterprise.

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

Contents Index String operators Join operators