Set the value of a specific bit in a bit array.

Syntax

SET_BIT([ bit-expression, ]bit-position [,  value ])

Parameters

Remarks

The default value of bit-expression is a bit array of length bit-position, containing all bits set to 0 (FALSE).

The default value of value is 1 (TRUE).

The result is NULL if any parameter is NULL.

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

See also

• GET_BIT function [Bit array]
• SET_BITS function [Aggregate]
• INTEGER data type
• Bitwise operators
• sa_get_bits system procedure

Standards and compatibility

Example

The following statement returns the value 00100011:

SELECT SET_BIT( '00110011', 4 , 0);

The following statement returns the value 00111011:

SELECT SET_BIT( '00110011', 5 , 1);

The following statement returns the value 00111011:

SELECT SET_BIT( '00110011', 5 );

The following statement returns the value 00001:

SELECT SET_BIT( 5 );