>>I know but I'm glad someone at last pointed out to use the name expression instead of unnecessary text...endtext and the slower &.
>>Cetin
>
>Good point. The only place we need to use macro is fields and where clauses (and join if we build it as string). So, we can try to minimize its usage.
>
>Though I'm not sure what is quicker:
>
>lcSelect = whole select string
>&lcSelect
>
>or
>
>select &lcFields from (lcTable) &lcJoin where &lcWhere into table (lcTable)

Join and where unlikely needs macro. Latter would be faster.
Cetin