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.

When i compile i get 'isNumeric' : undeclared identifierI thought that this works?Is there an equivalent?Using windows XP VC++ 6.0 #include #include using ...

To test for ISNUMERIC effectively, I needed to write a SQL Server CLR function and deploy the assembly into SQL Server itself. After confirming with the SQL Server DBA that a CLR function would be ...