+ 2

Is there any way to make all letters in lower case except first letter eg: NAVEEN to Naveen

5th Oct 2016, 11:37 AM
Naveen Kumar
Naveen Kumar - avatar
1 Resposta
+ 1
SELECT CONCAT(UPPER(LEFT([somecolumn],1)),LOWER(RIGHT([somecolumn],LEN([somecolumn])-1))) should do the trick :D
5th Oct 2016, 12:24 PM
Michael
Michael - avatar