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.
Splitting Strings Based on Patterns
Splitting strings based on patterns supported by LIKE and PATINDEX can be an interesting way to address a wide variety of problems.
2014-09-12 (first published: 2012-11-29)