How Can I Change Gender (Male to Female, Female To Male) In Sql 2000 Server Database?

I want to change gender where male there female and female where male how can i do it can you tell me any queryHow Can I Change Gender (Male to Female, Female To Male) In Sql 2000 Server Database?
You do it using only one UPDATE query:



UPDATE emp SET gender =

CASE gender WHEN 'M' THEN 'F' WHEN 'F' THEN 'M' ELSE gender ENDHow Can I Change Gender (Male to Female, Female To Male) In Sql 2000 Server Database?
Suppose the the table name is ';Employees';, gender column is ';Gender'; which keeps ';M'; for Male and ';F'; for female.



Then this SQL query should do the job:



UPDATE Employees, SET Gender='Z' WHERE Gender='F';

UPDATE Employees, SET Gender='F' WHERE Gender='M';

UPDATE Employees, SET Gender='M' WHERE Gender='Z';



Change the queries appropriately according to your needs.