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.

The stored procedure was performing a calculation on a SQL Server column of type nvarchar (50), using the SQL Server ISNUMERIC function to determine which text values could safely be included in the ...

I'm working on a project building a web site that helps craftsmen (bicycle framebuilders) manage their operations. Most bicycle framebuilders give their frames a serial number, which can be ...

This way I can take impossible-to-sort varchars, and sort them by the converted field instead, making the recordset prettier.<BR><BR>Right now SCNumber might look like the above, '99' implying ...