question

My favorite resource for delimited lists in t-sql is the "Arrays and Lists in SQL Server" articles by Erland Sommarskog - [ http://sommarskog.se/arrays-in-sql.html][1]. It basically comes down to using a numbers/tally table to parse the string using "],[" as a delimiter and removing the trailing ] and leading [ - maybe even wrapping it up in a helper UDF so you can use it again wherever you might need it. The problem has been covered numerous times on this site. Here are a couple previous questions/answers that may get you going: [ http://ask.sqlservercentral.com/questions/90968/how-do-i-extract-data-from-a-variable-length-delim.html][2] [ http://ask.sqlservercentral.com/questions/23117/how-has-splitting-a-delimited-string-improved-sinc.html][3] "delimited-string" even has its own tag if you'd like to see more: [ http://ask.sqlservercentral.com/questions/topics/delimited-string.html?sort=active&pageSize=50][4] [1]: http://sommarskog.se/arrays-in-sql.html [2]: http://ask.sqlservercentral.com/questions/90968/how-do-i-extract-data-from-a-variable-length-delim.html [3]: http://ask.sqlservercentral.com/questions/23117/how-has-splitting-a-delimited-string-improved-sinc.html [4]: http://ask.sqlservercentral.com/questions/topics/delimited-string.html?sort=active&pageSize=50