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

Syntax

GET_BIT( bit-expression, position )

Parameters

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

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

Standards and compatibility

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 );