Update "Male" into "Female" and "Female" into "Male" in Gender Column of a table in single line query.?

Post

By Vishwajeet Jha in SQL Server on Apr 23 2015

Feb, 2020 11

UPDATE table SET gender =
(CASE  WHEN  gender ='male' THEN 'female' else 'male' END)

Nov, 2019 2
Update customer set Gender= case when Gender=’F’ then ‘M’ when Gender=’M’ then ‘F’ end where Gender in(‘F’,’M’)
- 0
Jun, 2016 29
update table_Name set Gender= Case when Gender='Male' then 'Female' else'Male' end
- 0
Apr, 2015 23
Update table_name set Gender= case when Gender='Female' then 'Male' when Gender='Male' then 'Female' end where Gender in('Female','Male')
- 0

Most Popular Job Functions