• 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.