June 3, 2012 at 10:46 am
RBarryYoung (6/3/2012)
Jeff Moden (6/2/2012)
RBarryYoung (6/2/2012)
Jeff Moden (6/2/2012)
Thomas Stringer (6/2/2012)
SQLCLR is also a wise choice for complex string manipulationI'll say "IT DEPENDS". Let's have a race. You write a CLR function to solve the INITIAL CAPS problem to force all letters to be lower case and force any letter that doesn't follow a letter to be upper case. Of course the first character should be forced to upper case if it's a letter.
I'll do the same in T-SQL. I'll even give myself a handicap. Two, actually. I'll create a Scalar Function AND use a While Loop.
Once done, I'll be happy to provide a large test table and we'll see just how good CLRs actually are for "complex string manipulation". 😉
Umm, wasn't this already done in another thread Jeff?
It certainly was. 😉
Do you remember where that was? I'd like to take stab at it. 😀
Converting first letter of every word to uppercase
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 3, 2012 at 11:46 am
Thanks, opc.three.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
June 4, 2012 at 9:20 am
Wow! Thank you all for the insightful opinions. I would agree that its more specific to a problem that one is trying to solve.
Thank you all for taking time to respond to this question. 🙂
Viewing 3 posts - 31 through 32 (of 32 total)
You must be logged in to reply to this topic. Login to reply