I've successfully used VB.NET CLR functions to replace TSQL Scalar functions.

2 instances where it works well are >

1) Conversion of String IP Address data to numeric form (and back)

2) Extraction of Search Terms from Search Engine Http Referrer Urls.

I found the CLR string manipulation efforts for the latter outperformed the TSQL function 10 fold.

r