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