>>Here's a quick rewrite:
>
>>select * from collat.dbf into cursor QUERY1
>>QUERY = 'E'+SUBSTR(SYS(3),2,7)+'.DBF'
>>SELECT QUERY1
>>COPY TO (QUERY)
>>USE (QUERY) IN 0 ALIAS QUERY
>>SELECT QUERY
>>USE IN QUERY1
>
>Thanks for the code. Without seeming greedy, could you help me with another code snippet There is also a query2 and query3 that were tables, but now I have made them cursors. Want to append them each to QUERY. Actually QUERY could also be a cursor, because I trash it before the end of the proc.
>
>How is the best way to get cursor data to append to another table (or cursor)?
>
>Thanks - Brenda

You can use

SELECT table/cursor
APPEND FROM DBF('QUERY2') on either a table or a writeable cursor...