As yet another alternative... use with your favorite splitter...
http://www.sqlservercentral.com/articles/T-SQL/63003/
I also recommend NOT using a recurrsive CTE for such a thing because it's just too slow.
--Jeff Moden
Change is inevitable... Change for the better is not.