Home > IT Answers > Development > i want to change the true bits to false and vice versa
Sam53
5 pts.
 i want to change the true bits to false and vice versa
BIT data type, SQL Server 2000
i have a table where i have true and false bits..i need to replace the true bits to false and vise versa

Software/Hardware used:
ASKED: March 24, 2008  6:06 AM
UPDATED: May 14, 2008  9:01 AM
RELATED QUESTIONS
Answer Wiki:
You'll need to do this during a single UPDATE query. <pre>UPDATE Table SET Bitcolumn = CASE WHEN BitColumn = 0 THEN 1 ELSE 0 END</pre>
Last Wiki Answer Submitted:  May 14, 2008  9:01 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,520 pts.