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

Posted by Bandi under Sql Server category on 1/30/2015 | Points: 40 | Views : 766

Declare @Name Varchar(100) = 'sailaja kumari'

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

Bookmark It

Latest Code Snipptes