BITLSHIFT( ) Function
Moves bits in a numeric value to the left by the specified number of positions and returns the resulting value.
Note
If the specified expressions are not integers, they are converted to integers before performing the operation.
BITLSHIFT(nExpression1, nExpression2)
Parameters
nExpression1
Specifies the numeric value in which to move bits to the left.nExpression2
Specifies the number of bit positions to move to the left.
Return Value
Numeric. BITLSHIFT( ) returns the specified expression with bits moved by the specified number of positions.
Remarks
BITLSHIFT( ) does not support Varbinary values.
Example
x = 5 && 0101 binary
y = 1 && Shift bits 1 position left
? BITLSHIFT(x,y) && Returns 10, 1010 binary