T-SQL isn't particularly well suited to advanced string manipulation. I have found that small CLR functions that perform string manipulation and substring extraction perform very well in SQL Server.

SQL Server 2005 will integrate with the CLR, so you can deploy C# or VB.NET code within the SQL Server process. In this first of a two-part series, Shawn Wildermuth explains what's involved, and ...

To some extent, CLR is also SQL Server-independent. Although Microsoft’s .NET vision pre-dates the arrival of SQL Server 2000, the software giant didn’t deliver the first release of its .NET framework ...

I've googled for this on several occasions, but not really found any good information. I have a SQL 2005 CLR procedure that builds dynamic (parameterized) SQL. I basically have a main statement ...

CLR: Best for code that’s computation- or logic-intensive. A better option than “extended stored procedures,” which Microsoft offered in earlier SQL Server releases for creating server-side ...

CLR functions that perform string manipulation and substring extraction perform very well in SQL Server.