Mssql: Cannot use bitwise operators on varbinary or numeric

Ramon Smits — Mon, 25 Feb 2008 08:23:00 GMT

I want to perform bitwise operations on a varbinary colum. As it contains binary data I though that it would work but it didn't

This example works:

declare @a int
declare @b int

set @a = 1
set @b = 2

select @a | @b

But this wont:

declare @a varbinary(100)
declare @b varbinary(100)

set @a = 1
set @b = 2

select @a | @b

The same problem with numeric data type. So that currently leaves me without a mssql solution. I guess I have to fallback to code to perform the conversion that I need.

Search results matching tags 'SQL', 'bitwise operators', 'MSSQL', 'tsql', and 'numeric'

Mssql: Cannot use bitwise operators on varbinary or numeric