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
Dynamics GP - Learn & Discuss 
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
LikeLike
Thank you so much, Kelvring, for sharing this link.
LikeLike
How to use this function with Insert or Select Query?
LikeLike
Functions are used like how you call proper columns. I would recommend to you to read the manuals for T-SQL functions.
LikeLike