Hi Klas

Maybe not the most elegant solution, but certainly one that would work is

select * from [your table] where [pick 1 record] into table [temporary table]
select [your table]
append from [temporary table]

this would copy and insert any selected records, including the general field contents. I would prefer to use a cursor, but the help says you need to append from either a file or an array, so you need to delete the temp table afterwards.

greetings
derk