carl.anderson-1037280 (4/1/2010)
when I run your example code, I get a separate resulting row for every character I'm trying to exclude. I don't see the same behavior in Jeff's code. Are you sure these are equivalent solutions, or am I doing something wrong? It looks like each individual row returned by your procedure has removed one of the different excluded characters.
Hey Carl,
Thanks so much for posting here - it sent me an email notification! I have been trying to track this thread down for a few weeks now, since I first realised that the in-line TVF is not equivalent after all - the trick with the multiple-variable assignment is the thing.
I am busy with something else just at the moment, but will correct my posts and submit a revised version in the next few days.
Thanks again!
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi