Quaint Query for Quick Bit Flip

Written by Jamie McBurney
Posted on Oct 3, 2012 at 10:57 AM

How's this for the a super simple way to flip a bit field from 1 to 0 and back:

UPDATE myTable





SET myBitField = coalesce(myBitField,0) ^ 1





WHERE myPrimaryKey = 'uniqueIDHere'

I'm in love.

Share and Subscribe:

Tags:

Name: Rob Matlow
Posts: 118
Last Post: June 30, 2022
Show Rob's Posts

Name: Sanj Rajput
Posts: 29
Last Post: June 27, 2022
Show Sanj's Posts

Name: Sean Sanderson
Posts: 65
Last Post: January 24, 2022
Show Sean's Posts

Name: Haley Burton
Posts: 1
Last Post: December 7, 2021
Show Haley's Posts

Name: Generic Administrator
Posts: 1
Last Post: December 3, 2021
Show Generic's Posts

Name: Colleen Legge
Posts: 1
Last Post: November 26, 2021
Show Colleen's Posts

Name: Christine Votruba
Posts: 30
Last Post: November 3, 2021
Show Christine's Posts

Name: Sean McParland
Posts: 18
Last Post: August 20, 2021
Show Sean's Posts

Name: Ryan Covert
Posts: 48
Last Post: July 26, 2019
Show Ryan's Posts

Name: Matt Stern
Posts: 4
Last Post: July 16, 2019
Show Matt's Posts

Name: Sean Legge
Posts: 1
Last Post: June 28, 2019
Show Sean's Posts

Name: Todd Hannigan
Posts: 47
Last Post: November 13, 2018
Show Todd's Posts