Search code examples
sql-serveruppercase

SQL Server how to change 1 letter from lower case into upper case?

I have column that contains many row. Each row has value about 3 words. I want to change first letter of that value into upper case. Only first letter, example abc def ghi into Abc def ghi. Please help me. Thank !!

Solution

  • DONE !! thx all

    UPDATE table SET column= CONCAT(upper(LEFT(column, 1)), 
                         SUBSTRING(column, 2,100));