BITSET() and BITTEST () with Varbinary(2)

[stepen123]

Hello,
I have a field pos_bin, which is Varbinary(2).

The following command:

REPLACE pos_bin WITH BITSET(pos_bin,1)

produces 0200 in the field and

REPLACE pos_bin WITH BITSET(pos_bin,8)

gives 0201.

How can I revert the result, so that when I set bit #0 I get 0001 and when I set bit #8 I get 0100? Why is the least significant byte on the left?

Regards,
Stephen

 

[Olaf Doschke]

See Varbinaries like a string displayed in hexeditor format, then it's clear why the first byte is left and not right. That's the way it is.

Bye, Olaf.