I have found that small CLR functions that perform string manipulation and substring extraction perform very well in SQL Server. To test for ISNUMERIC effectively, I needed to write a SQL Server CLR ...

Is it possible to order by a substring in a returned field ... I can't think of how I'd do this in SQL, but before I give up and just write code to deal with it, can someone else come up with ...