SDU Tools: Separate T-SQL Strings By Case
If you’ve ever used SQL Server Reporting Services, you’ll notice that when you drag a database column into a table, it auto-magically converts the name of the column into a more English-readable name.
[caption id=“attachment_2791” align=“alignnone” width=“429”]
Image from MSDN[/caption]
Notice how when the LineTotal column has been dragged into the table, the heading has been set to Line Total with a space. What it is doing is taking a Pascal-cased or camel-cased name and separating the words with spaces, based upon where the capital letters are.
In our free SDU Tools, we have a tool that does that as well.
In the example above, you can see both a Pascal-cased phrase and a camel-cased phrase that has been separated.
You can see it in action here:
For more information on our SDU Tools, and to join our SDU Insiders to get them and our other free resources, please just look here:
http://sdutools.sqldownunder.com
2018-02-28