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

SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Reference » Using SQL » SQL functions » SQL functions (E-O)

 

GET_BIT function [Bit array]

Returns the value (1 or 0) of a specified bit in a bit array.

Syntax
GET_BIT( bit-expression, position )
Parameters
  • bit-expression   The bit array containing the bit.

  • position   The position of the bit for which to return the status.

Returns

BIT

Remarks

The positions in the array are counted from the left side, starting at 1.

If position exceeds the length of the array, 0 (false) is returned.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.

Example

The following statement returns the value 1:

SELECT GET_BIT( '00110011' , 4 );

The following statement returns the value 0:

SELECT GET_BIT( '00110011' , 5 );