We have following data in SQL.
Now I want to display data in sentence case like as below.
T-SQL
DECLARE @TableX TABLE(Name VARCHAR(100))INSERT INTO @TableXSELECT 'shatrughna kumar' UNION ALLSELECT 'SHATRUGHNA KUMAR' UNION ALLSELECT 'PeTER Mac'SELECT SUBSTRING(UPPER(Name),1,1)+SUBSTRING(LOWER(Name),2,LEN(Name)-1)AS 'Result' FROM @TableX
That’s It.
Enjoy Learning.
No comments:
Post a Comment