Scalar. Returns the value of a specific bit in a binary value.
Syntax
BITTEST(
expression, bit
)
Parameters|
expression
|
The initial value.
|
|
bit
|
Which bit to return. All other bits are set to zero.
|
Data Types|
Return
|
expression
|
bit
|
|---|
|
Integer
|
Integer
|
Integer
|
|
Long
|
Long
|
Integer
|
Example
INSERT INTO OutStream
SELECT BITTEST(InStream.IntColumn,1)
FROM InStream;