We collect basic website visitor information on this website and store it in cookies. We also utilize Google Analytics to track page view information to assist us in improving our website.
Small Business Blog > Jamie McBurney > Quaint Query for Quick Bit Flip
How's this for the a super simple way to flip a bit field from 1 to 0 and back:
SET myBitField = coalesce(myBitField,0) ^ 1
WHERE myPrimaryKey = 'uniqueIDHere'
I'm in love.