At http://www.sqlsharp.com/features/ there is a series of SQL CLR functions for SQL Server 2005 and later. The basic set can be downloaded for free! For $200, an additional 50+ functions are available.
The benefit of using them is well argued at http://www.simple-talk.com/content/article.aspx?article=1353