I woud use TEXTMERGE and Name expressions

TEXT TO lcSql TEXTMERGE NOSHOW PRETEXT 15
SELECT <<latmp[1]>> as <<lcnewfield>> 
  FROM (lcoldfile) 
  INTO TABLE (lcnewfile) DATABASE (lcTAbleDbc)
ENDTEXT
&lcSql

>
> I am trying to set up a select statement, I do not know the field name ahead of time. I do an AFIELDS() to get the field name, since there is only one field in the table. I need to change the field name to another name which I get before this select statement. I am thinks this way:
>

>SELECT EVALUATE(latmp[1]) as &lcnewfield. FROM &lcoldfile. ;
>   INTO TABLE lcnewfile DATABASE &lcTAbleDbc.
>

>
>Am I using the macro substitution too much? Can I do this easier? or nicer?
>
>TIA
>Beth