>>I find it much easier to read code that contains the actual SQL command than code that builds a string and executes it.
>
>Tamar,
>what is the difference (for reading the code) between these:
>

>TEXT TO lcSQL NOSHOW PRETEXT 15 TEXTMERGE
>     SELECT <<aLine[1]>> AS <<BlaBla>>
>           FROM ....
>ENDTEXT
>&lcSQL
>

>
>and this:
>

>SELECT (aLine[1]) AS (BlaBla)
>       FROM ....
>

>

In the first case, I have to stop and figure out that a query is being built on the fly, then executed. The second case is obvious. But that's me. YMMV.

Tamar