I was intersted in using bitwise operation because

Col & mask, and trying to find the "mask" value to get the following result

-2...

I was trying to use the bit wise like

Col & mask

and -2 & mask= ' '

-1 & mask= ' '

-2...

The original table values are int, but it should be converted to char. This is the way I did it. but the performance is slow.

SELECT

...

It is just updating the table (5 columnX20,000,000 records= 100,000,000). and the performance of the case statement is a little bit slow. I was thinking bitwise operation might be...

The table has about 20 million records and the case statement is slow. I just want to improve the performance using the bitwise operation.

Alex

Txs