>>The name expression will not work for '(laTmp[1])' because it's expression not a name.
>>
>>SELECT EVALUATE(laTmp[1]) AS (lcNewField) ;
>> FROM (lcOldFile) ;
>> INTO TABLE lcNewFile DATABASE (lcTableDBC)
>>
>
>You're right. Makes sense when I think about it, but I'd have sworn I'd done it that way. Guess not.
>
>Tamar
It would work, but it's inefficient in Select-SQL.
If it's not broken, fix it until it is.
My Blog