SQLCLR and Collations
September 23, 2009[From SQL Server Magazine]
An important quality of a well-written SQL Server Common Language Runtime (SQLCLR) routine is transparency: A caller should never have to think about, or even realize, that a given routine was written in a .NET language rather than in T-SQL. As developers, therefore, our job is to be mindful of the differences between the two systems so that we can create routines that behave the way weand our end usersexpect them to.
The article continues at http://www.sqlmag.com/Articles/ArticleID/102852/102852.html?Ad=1