Change Gender (Male to Female, Female To Male) In Sql Server

UPDATE emp SET gender =
CASE gender WHEN 'M' THEN 'F' WHEN 'F' THEN 'M' ELSE gender END