telastruct (12/30/2010)
Actually, I did test it and it works great. I tested it on a table with almost 4 million rows and it only took a minute or two.
Now try the 'nested REPLACE' code Jeff referred to.
You should find it's much faster (and more efficient).
Actually.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi