Thank this author by sharing:
By Sean Cooperman,
Pass in the string you wish to check for proper case. If you separate the string by spaces it will check each word and capitalize the first letter. You can pass in as many words separated by a space as you wish. I hope you enjoy this function.
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.