Two Varbinary fields' bitwise operation
Posted on 2007-11-14
I'm badly looking for a solution which is related to the issue as below. Any help is highly apreciated.
I've created a table as
CREATE TABLE MyBinaryTable
(Field1 VARBINARY(100), Field2 VARBINARY(100), Result VARBINARY(100))
Now what I need is I want to execute bitwise OR or AND operation between Field1 and Field2 and store in Result field. My Field values are like
I cannot convert these values to BIGINT because they are big enough.
Is there a way to execute bitwise operation between these?