We do not have a built in T-SQL function to convert any string (or a statement) to Proper Case format, also known as Title Case. This I feel is a very simple feature that SQL Server could have provided us, but missing even in it’s latest version, SQL Server 2012.
I thought I would highlight some links which would be useful for T-SQL programmers in our community:
There are many more solutions, but above are noteworthy.
VAIDY
I found this solution, which is worth a look too, it works particularly well with difficult name exceptions.
http://www.jasinskionline.com/TechnicalWiki/Proper-Case-Function-SQL-Server.ashx
Thank you so much, Kelvring, for sharing this link.