We have several assemblies that we built for performing some needed string manipulation like regular expressions, with enhanced lookups on the replacement expressions. We have also built several Aggregate functions that perform complex attribute weighting based on a configuration parameter. Together those two assemblies have saved us hundreds of hours and also kept our code more concise and maintainable. We have not needed to author any CLR stored procedures -- most of this kind of logic gets written in our app server layers.

Cheers

R. Oz.