GET_BIT( bit-expression, position )

BIT

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.

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

The following statement returns the value 1:

SELECT GET_BIT( '00110011' , 4 );

The following statement returns the value 0:

SELECT GET_BIT( '00110011' , 5 );