JavaScript Editor js editor     Web development 



Main Page

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

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

See Also



JavaScript Editor js editor     Web development