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

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