Scalar. Returns the value of an expression after setting a specific bit to zero.
Syntax
BITCLEAR(
expression, bit
)
Parameters|
expression
|
The initial value.
|
|
bit
|
Which bit to clear, starting from 0 as the least-significant bit.
|
Data Types|
Return
|
expression
|
bit
|
|---|
|
Integer
|
Integer
|
Integer
|
|
Long
|
Long
|
Integer
|
Examples
INSERT INTO OutStream
SELECT BITCLEAR(InStream.IntColumn,2)
FROM InStream;