Hi

String has first charcter only upper case another lower case in sql Server

select  CONCAT(UPPER(LEFT(c.Name,1)),LOWER(RIGHT(c.Name,Len(c.Name)-1))) from c

Previous
Next Post »