In this post, we want to discuss a nice function to convert text to title case (Proper Case) in SQL Server. With this function, you can easily convert your desire test to a title case. Before we get started, if you want to know about split with any delimited string, please go through the following article: How to Split comma delimited string into a Table in SQL Server

The following function will convert any string to Title Case. I have this function for a long time. I do not remember that if I wrote it myself or I modified it from original source. Run Following T-SQL statement in query analyzer:

SELECT dbo.udf_TitleCase('This function will convert this string to title case!')

The output will be displayed in the Results pan as follows:

T-SQL code of the function is:

Function to Convert Text to Title Case – Proper Case

The article was published on August 31, 2014 @ 9:57 AM

Leave a Comment