[thelist] Comma delimited string in SQL

Joel D Canfield joel at spinhead.com
Mon Oct 13 09:37:59 CDT 2003


> I have comma delimited string i.e. 1,2,4,5. I want to loop 
> through each data in the string as i insert the data in a table.

Hard to say *exactly* without knowing what language(s) you're using, but
essentially you need to 'split' (the VBScript term) the string on the
comma, then loop through the resulting array

With more details I could be more specific.

spinhead


More information about the thelist mailing list