BITSET()

Scalar. Returns the value of an expression after setting a specific bit to one.

Syntax

BITSET( expression,bit )
Parameters

expression

The initial value.

bit

Which bit to set, starting from 0 as the least-significant bit.

Data Types

Return

expression

bit

Integer

Integer

Integer

Long

Long

Integer

Example

INSERT INTO OutStream
SELECT BITSET(InStream.IntColumn,4)
FROM InStream;