I ahve to interchange two columns value by 1update query

[anj]

Hello,

I have 1 table in MS SQl named Emyloee which contains two column,named NAme and Sex.Wrong values are entered by developer in column Sex.i.e. all
female employee sex are entered as Male and vice versa as shown in below

Name Sex
Anjana Male

Ranjana Male

Ashish Female

Now i want to interchane these value only by 1 upadte query.How can I do this.

Pls. help me.

Anjana

[Cstick]

UPDATE Emyloee SET Sex = CASE Sex WHEN 'Male' THEN 'Female' ELSE 'Male' END