# #1667 Fix Names in a Table

#### [https://leetcode.com/problems/fix-names-in-a-table/](https://leetcode.com/problems/fix-names-in-a-table/)

{% tabs %}
{% tab title="MS SQL Server" %}
```sql
SELECT user_id,
    CONCAT(UPPER(LEFT(name, 1)),LOWER(SUBSTRING(name, 2, LEN(name)))) AS name
FROM Users
ORDER BY user_id
```
{% endtab %}
{% endtabs %}
