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 Functions » Alphabetical list of functions

BIT_AND function [Aggregate] Next Page

BIT_OR function [Aggregate]


Takes n bit arrays and returns a bitwise OR-ing of its arguments using the following logic: for each bit compared, if any bit is 1, return 1; otherwise, return 0.

Syntax

BIT_OR( bit-expression )

Parameters

expression    The expression for which the value is to be determined. This is commonly a column name.

See also
Standards and compatibility
Example

Suppose you have the following table, t, containing a single column, a, which is a VARBIT data type.

a
0001
0111
0100
0011

You want to know the OR value for the column. You enter the following SELECT statement, which returns 0111:

SELECT BIT_OR( a ) FROM t;

This result is determined as follows:

  1. Row 1 (0001) is compared with Row 2 (0111), and results in 0111.

  2. The result from the previous comparison (0111) is compared with Row 3 (0100), and results in 0111.

  3. The result from the previous comparison (0111) is compared with Row 4 (0011), and results in 0111.