It's from a few years ago, but I've found Erland Sommarskog's entry on this to be the most comprehensive:
http://www.sommarskog.se/arrays-in-sql-2005.html#Split
We ended up using a modified version of his CLR function in our application. Sped things up a lot.