Performs a bitwise NOT operation on a value of Numeric, Varbinary, or Blob type and returns the bitwise complement on the specified value. There is a numeric and a binary version of the syntax.

Note
If the specified expression is not an integer, it is converted to an integer before performing the operation.

BITNOT(nNumericExpression)

BITNOT(BinaryExpression [, nStartBit [, nBitCount]])

Parameters

nNumericExpression

Specifies a Numeric value to perform the bitwise NOT operation.

BinaryExpression

Specifies a Varbinary or Blob value to perform the bitwise NOT operation.

[ nStartBit[, nBitCount]]

Specifies nStartBit as the starting zero-based number of the first bit to perform the operation and nBitCount as the number of bits to perform the operation.

If you do not specify nStartBit and nBitCount, the operation applies to all bits in the expression. If you specify nStartBit only, the operation applies to nStartBit only.

Return Value

Example

	Copy Code
x = 5 && 0101 binary ? BITNOT(x) && Returns -6

See Also