Gordon,
Try APPEND FROM (sTablename)
>What is the proper syntax for using a variable which holds a table's name instead of a literal table name with the APPEND FROM statement?
>I am changing the table's name dynamically in a prior step.
>
>Is it something like this ?
>
> ex.
>
> local array aNames{'jones', 'smith', thomas'}
> local sTablename, i
>
> for i = 1 to 10
> sTablename = "MY_NEW" + aNames
> Append from sTablename
> next
>
>
> Thanks for the help !
Doug Stalter
"According to the proverb, the best things are the most difficult." -Plutarch