137_fix_names_in_a_table.md

SQL Everyday #137

Fix Names in a Table

Site: LeetCode
Difficulty per Site: Easy

Problem

Write a solution to fix the names so that only the first character is uppercase and the rest are lowercase.

Return the result table ordered by user_id. [Full Description]

Submitted Solution

-- Submitted Solution
SELECT 
    user_id
    ,CONCAT(UPPER(SUBSTRING(name, 1, 1)), LOWER(SUBSTRING(name FROM 2))) AS name
FROM Users
ORDER BY user_id
;

Site Solution

-- LeetCode Solution 
-- TBD

Notes

TBD

NB

SUBSTRING()

Go to Index
Go to Overview