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

Answer 1

SELECT CONCAT(UPPER(LEFT([somecolumn],1)),LOWER(RIGHT([somecolumn],LEN([somecolumn])-1))) should do the trick :D