THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - 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

This blog has moved! You can find this content at the following new location:

http://greglow.com/index.php/2017/04/07/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

Comments

 

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

(required) 
(required) 
Submit

This Blog

Syndication

Tags

No tags have been created or used yet.

Archives

Privacy Statement