title: How to recreate the InitCap() function in T-SQL to apply first-letter capitalization to a string?
body: <p>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;</p>
  
  <p>"ABC COMPANY"</p>
  
  <p>"DEF PLASTICITY"</p>
  
  <p>as</p>
  
  <p>"Abc Company"</p>
  
  <p>"Def Plasticity"</p>
  
  <p>I know that I should use "UPDATE" command. But How? Thanks for your help!</p>
  
  <p>(CONCAT does not work)</p>