UPDATE Table_Name SET Column_Name = CASE Column_Name WHEN 0 THEN 1 WHEN 1 THEN 0 END
UPDATE YourTable SET YourTable.ColWith0or1 = CASE WHEN YourTable.ColWith0or1 = 0 THEN 1 ELSE 0 END
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)