For anyone who does not yet have SQL Server 2005, here's an article for achieving similar results using a UDF in SQL Server 2000...
http://www.windowsitpro.com/Article/ArticleID/26094/26094.html?Ad=1 (written by Tim Pfeiffer)
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.