>>Although most of the others recommend textmerge, I wouldn't bother in this case where name subsitution is enough. I find it much easier to read code that contains the actual SQL command than code that builds a string and executes it. While I haven't tested, I see no reason why this version would be slower.
>>
>>Tamar
>
>Oh I was feeling alone:) Thanks.
>Cetin

Cetin,

You posted correct solution, but Tamar made a mistake.

SELECT (laTmp[1]) AS (lcNewField) ; && Here it should be &laTmp[1] instead
>  FROM (lcOldFile) ;
>  INTO TABLE lcNewFile DATABASE (lcTableDBC)