MSSQL 2012 - Query to convert the first character of word in the string provided as input, to upper case and remaining characters to lower case

Bandi
Posted by Bandi under Sql Server category on | Points: 40 | Views : 160
Declare @Name Varchar(100) = 'sailaja kumari'

SELECT CONCAT(UPPER(SUBSTRING(@NAME,1,1)),LOWER(SUBSTRING(@NAME,2,LEN(@NAME))))

Comments or Responses

Login to post response