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

GET_BIT function [Bit array]

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

GET_BIT( bit-expression, position )

bit-expression    The bit array containing the bit.

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

The first bit in the array is considered position 1.

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

• Bitwise operators
• SET_BIT function [Bit array]
• SET_BITS function [Aggregate]
• sa_get_bits system procedure

SQL/2003    Vendor extension.

The following statement returns the value 1:

SELECT GET_BIT( '00110011' , 4 );

The following statement returns the value 0:

SELECT GET_BIT( '00110011' , 5 );