After confirming with the SQL Server DBA that a CLR function would be permitted on the production SQL Server, I wrote the function that appears in Listing 1. You'll notice it uses the Microsoft.Net ...

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

When selecting the data, I was expecting the zero values to be returned as 0.00 or 0, but they were returning as .00.<BR>So, I changed some fields to numeric (8,2), hoping that would help.

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