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

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


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