• You shouldn't store lists for delimited values in a single line for a single value. It violates the first normal form.

    If you really need this (I suggest to use it only for display or email generation purposes), you could use the method described in this article: http://www.sqlservercentral.com/articles/comma+separated+list/71700/

    This is really fast and you don't need to store the values as arrays.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2