SQL Server
\nupdate salary \nset sex = \ncase \n  when sex = \'m\' then  \'f\'\n  else \'m\'\nend \n
```\nupdate salary \nset sex = \ncase \n  when sex = \'m\' then  \'f\'\n  else \'m\'\nend \n```
['MySQL', 'MS SQL Server']