BITTOGGLE()

Scalar. Returns the value of an expression after inverting the value of a specific bit.

Syntax

BITTOGGLE( expression,bit )
Parameters

expression

The initial value.

bit

Which bit to toggle.

Data Types

Return

expression

bit

Integer

Integer

Integer

Long

Long

Integer

Example

INSERT INTO OutStream
SELECT BITTOGGLE(InStream.IntColumn,0)
FROM InStream;