I've used SqlCLR once in Production.

I ETL'd some data from a DB2 database on iSeries into SQL Server 2005. The data included product descriptions, and for some reason the trademark symbol (™) refused to display as a printable character. I tried every T-SQL trick I could think of to search and replace that character, and for whatever reason, I could not figure out how to find the unprintable character in the column.

I wrote a search and replace function that accepted a database name, schema.table name, column name, search string, and replace string. It worked very well.

:{> Andy