david.rowland (5/7/2012)
Although RegEx is powerful, I have tried using it once and found that coding my own CLR function to manipulate strings to what I want was 100 times faster than the RegEx function was.If you are running the code against a small dataset this should not matter however I was running the code against millions of rows and this had a major impact on performance.
What did your custom CLR do to beat Regex so soundly?
--Jeff Moden
Change is inevitable... Change for the better is not.