I have a bitmasked int field in my database. Usually I manage it through c# code, but now I need to flip a bit in the mask using T-SQL
How do I accomplish the following:
The bit i want to flip: 1 << 8 (256)
The mask value before i flip: 143
The mask value after i flip: 399
I'm not exactly a bit-flipping wizard but this can be done without the bit operators that's missing in tsql, right?