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

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 ...