How To Update 'yes' To 'no' And Viceversa In A Query?

1.	How To Update 'yes' To 'no' And Viceversa In A Query?
Answer» UPDATE TABLENAME set ColumnName1 = (case ColumnName1 when 'Yes' then 'No' ELSE 'Yes' end). Update tablename set ColumnName1 = (case ColumnName1 when 'Yes' then 'No' else 'Yes' end).

Answer»

UPDATE TABLENAME set ColumnName1 = (case ColumnName1 when 'Yes' then 'No' ELSE 'Yes' end).

Update tablename set ColumnName1 = (case ColumnName1 when 'Yes' then 'No' else 'Yes' end).

Discussion