You're right, doing it all in one Select is better.

Thanks.

>
>
>Make sure that none of the field names in the freetable exceed a length of 10, otherwise the ALTER TABLE command will generate an error. In the example you posted, would it not be easier to just change your SQL as follows:
>
>

>SELECT *, SPACE(40) AS coco from freetable into cursor iamfree nofilter readwrite
>