I have a table on my database. My table's name is "Company". I want to change data "company_name" as upper case first letter. For example; "ABC COMPANY" "DEF PLASTICITY" as "Abc Company" "Def Plasticity" I know that I should use "UPDATE" command. But How? Thanks for your help! (CONCAT does not work)

How to recreate the InitCap() function in T-SQL to apply first-letter capitalization to a string?

Created Jul 27, 2012 Edited Jul 27, 2012

Viewed 63915

I have a table on my database. My table's name is "Company". I want to change data "company_name" as upper case first letter. For example;

"ABC COMPANY"

"DEF PLASTICITY"

"Abc Company"

"Def Plasticity"

I know that I should use "UPDATE" command. But How? Thanks for your help!

(CONCAT does not work)