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