how to update a bit field

See more:

SQL-Server-2005

SQL-Server

Hi all,

I have a table with two column i.e ID,Status (int,bit)
1 0
2 1
3 0
4 0
5 1
I have to write a query to update bit field i.e 1 will be 0 and 0 will be 1.
can anybody help me?

thanks and regards
raghvendra kumar Roy