T-SQL Function for Proper Case Format

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:

1. David Wiseman’s Solution
2. Jeff Smith’s Solution
3. Pinal Dave’s Solution

There are many more solutions, but above are noteworthy.

VAIDY