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