# #627 Swap Salary

#### [https://leetcode.com/problems/swap-salary/](https://leetcode.com/problems/swap-salary/)

{% tabs %}
{% tab title="MS SQL Server" %}
```sql
UPDATE Salary
SET sex = CASE WHEN sex = 'm' THEN 'f' ELSE 'm' END
```
{% endtab %}
{% endtabs %}
