November 16, 2011

Make string sentence case in SQL

We have following data in SQL.

image

Now I want to display data in sentence case like as below.

image

T-SQL

DECLARE @TableX TABLE
(Name VARCHAR(100))
INSERT INTO @TableX
SELECT 'shatrughna kumar' UNION ALL
SELECT 'SHATRUGHNA KUMAR' UNION ALL
SELECT '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