Adam Machanic has a clr table valued function to split a string on a delimiter(http://sqlblog.com/blogs/adam_machanic/archive/2009/04/26/faster-more-scalable-sqlclr-string-splitting.aspx). Here's an adaptation of his clr that I put together in vb.net to get...