A much more efficient version is available here,

http://philcart.blogspot.com/2007/06/split-function.html

It uses varchar(max), so you're not limited in how many values are passed. Doesn't use a loop, so the number of values passed doesn't affect performance.