THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Greg Low (The Bit Bucket: IDisposable)

Ramblings of Greg Low (SQL Server MVP, MCM and Microsoft RD) - SQL Down Under

Converting T-SQL strings to Proper Case, Camel Case, Snake Case, or Kebab Case

Published Friday, April 7, 2017 10:53 AM by Greg Low

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



GaryV said:

Interesting.  We've got some homemade functions that try to get to proper case, with varying results.

How does your product handle a name like Manfred Albrecht Freiherr von Richthofen (aka The Red Baron), where "von" is properly lower case?

Or a name with a capital in the middle, such as a Dutch name like VanDyke, which is sometimes Van Dyke or sometimes van Dyke?

And what about address systems like those in Washington DC or Grand Rapids MI, where "NE" or "SW" is part of the address?  Ours requires special coding so it doesn't convert it to "Ne" and "Sw".

April 10, 2017 7:44 AM

Leave a Comment


This Blog



No tags have been created or used yet.


Privacy Statement