SQL Server Gender Swap Query
- by Sanju
I have a Table having the following column:
ID, Name, Designation, Salary, Contact, Address, Gender
Accidentally for all male Gender i have entered 'Female' and similarly for all Female gender i have entered 'Male'. For Exmaple
0023 Scott Developer 15000 4569865 Cliff_Eddington,USA Female
I the above line There should be Male instead of female. And there are all Male whose gender has been updated as Female. Same case for all Female Gender has been updated as Male.
Is there any Single query through which i can change all the Rows whose Gender is Male Change it to Female and All the Rows whose Gender is Female Change it to Male.