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.
If the specified expression is not an integer, it is converted to an integer before performing the operation.
BITNOT(BinaryExpression [, nStartBit [, nBitCount]])
Specifies a Numeric value to perform the bitwise NOT operation.
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.
Numeric, Varbinary, or Blob. BITNOT(В ) returns the bitwise complement of the specified expression. In other words, the return value represents the specified expression with each 0 bit changed to 1 and each 1 bit changed to 0.
|В ||Copy Code|
x = 5 && 0101 binary
? BITNOT(x) && Returns -6