SQL SERVER – UDF – Function to Convert Text String to Title Case – Proper Case – Part 2

I had previously written SQL SERVER – UDF – Function to Convert Text String to Title Case – Proper Case and I had really enjoyed writing it. Above script converts first letter of each word from sentence to upper case.

For example
this function will convert this string to title case!
will be converted to
This Function Will Convert This String To Title Case!
However if you just want to convert first word of complete sentence you can use following quick script.

USE AdventureWorks
GO
DECLARE @varString VARCHAR(100)
SET @varString = 'this function will convert this string to title case!'
SELECT UPPER(SUBSTRING(@varString,1,1))+SUBSTRING(@varString,2,LEN(@varString))
GO

For example
this function will convert this string to title case!
will be converted to
This function will convert this string to title case!
If you have column of table which needs to be converted to “sentenced case” – where only first char of sentence is upper cased.

Following script written by Imran will show how to convert the first char of sentence or word group to be upper case in any table.

USE AdventureWorks
GO
CREATE TABLE example (ename VARCHAR(100))
GO
INSERT INTO example
VALUES ('good morning')
INSERT INTO example
VALUES ('hello')
GO
SELECT UPPER(SUBSTRING(ename,1,1))+SUBSTRING(ename,2,LEN(ename))
FROM example
GO
DROP TABLE example
GO

Reference : Pinal Dave (https://blog.sqlauthority.com)