BITNOT( ) Function
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
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.
Example
x = 5 && 0101 binary
? BITNOT(x) && Returns -6