In this post, we want to discuss about a nice function to convert text to title case (Proper Case) in SQL Server. With this function you can easy convert your desire test to 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

Following function will convert any string to Title Case. I have this function for long time. I do not remember that if I wrote it myself or I modified 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 Results pan as follows:

T-SQL code of the function is:

Function to Convert Text to Title Case – Proper Case

Leave a Comment