Sean Lange (7/31/2012)

---

The splitter that Lynn mentions is awesome at splitting strings. However it sounds like you are looping in the front end to get the selected values? Assuming that you are using 2008 you could also look at passing in a table valued parameter instead. In the front end instead of building a comma separated list, you add rows to a dataset and pass that dataset to sql as a parameter. SQL can now treat that like a table.