>>first
>I was surprised at the results. The table has about 70,000 records. But the Select SQL is noticeably slower.

as u said in another msg it is probably just the slight overhead of the
SELECT itself

>>regarding option 2 - why use an array, u can simply CREATE CURSOR and copy directly into it
>
>Needed to capture the Recno() of the records extracted from the original table. Can't do that with CREATE CURSOR because neither COPY TO nor APPEND FROM support anything but field names.

adding a single REPLACE for the RECNO() takes less code :)

Arnon