To add the list of recommended readings regarding parsing a delimited string, I find Erland Sommarskog's articles are very helpful:

http://www.sommarskog.se/arrays-in-sql-2005.html

http://www.sommarskog.se/arrays-in-sql-2000.html