• Skip to primary navigation
  • Skip to content
  • Skip to footer
Thomas Ngo Thomas Ngo
  • Home
  • Journal
  • Tags
  • About

    Thomas Ngo

    Software Engineer

    • Stanton, California
    • Email
    • GitHub
    • Resume

    SQL problem - Fix Names in a Table

    March 3, 2024 less than 1 minute read

    Page Navigation

    • Problem
    • Query
    • Editorial Solution

    Problem

    problem-1667

    Query

    SELECT
        user_id,
        CONCAT(UCASE(LEFT(name, 1)), LCASE(SUBSTRING(name, 2))) as name
    FROM
        Users
    ORDER BY
        user_id
    

    Editorial Solution

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

    Tags: SQL

    Updated: March 3, 2024

    Share on

    Twitter Facebook LinkedIn
    Previous Next

    You may also enjoy

    Problem of The Day: Numbers With Same Consecutive Differences

    October 5, 2025 1 minute read

    Problem Statement

    Problem of The Day: Combination Sum III

    October 5, 2025 less than 1 minute read

    Problem Statement

    Problem of The Day: Largest Perimeter Triangle

    September 28, 2025 less than 1 minute read

    Problem Statement

    Problem of The Day: Triangle

    September 24, 2025 less than 1 minute read

    Problem Statement

    • Follow:
    • GitHub
    • LinkedIn
    © 2025 Thomas Ngo.