Ever had to deal with series of data which is all in upper case? Corresponding with clients and screaming their name at them isn’t a good look. What is required is function to convert or transform the upper case data into proper names. For example JOE BLOGS should be Joe Blogs.
Well if you are using Oracle you can use the InitCap string function. However in Microsoft SQL world there is no equivalent. Luckily it’s no big deal to implement your own InitCap function in Transact-SQL. The guys over at SQL Server Help have a great example here.