I am not sure I understand exactly what you need. Do you have a comma-delimited list (something like "USA,Canada,England") that you need to parse and insert into one column in a table?
Roman
>Dear all,
>
>I want to use a sql statment (support by SQL Server 2k) to write a list of data into a recordset. Let say i want to put "USA","Canda","British" into a column called "Country", how can i do this?
>
>I think it is really a stupid question, I remember I have written it in SQL Postgre, but forgot the syntax. please help.
>
>Thanks
>Aston
Roman Rehak, MCSD, MCDBA, MCSA
Competitive Computing
354 Mountain View Drive
Colchester, VT 05446-5824
802-764-1729