[thelist] Comma delimited string in SQL

[rudy]

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

do this in your scripting language, not in sql

you didn't say what that was

if it's coldfusion i can help you

in sql it's rather hideous

see the code snippet by joe celko at the bottom of this article --

   How to do looping in SQL
   http://tinyurl.com/qqje
   (registration is required, but it's free)

rudy