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;