Or addd one line of code to replace CRLF with a space

TEXT TO lcstrsql TEXTMERGE NOSHOW PRETEXT 7
      SELECT * from <<lcTable>>
        ORDER BY <<lcTag>> <<lcDirection>>
        INTO CURSOR <<lcNTable1>> nofilter
ENDTEXT
lcstrsql = STRTRAN(lcstrsql, CHR(13)+ CHR(10), SPACE(1))
&lcstrsql.

>Missing a ";" at the end of each lines:

TEXT TO lcstrsql TEXTMERGE NOSHOW PRETEXT 7
>      SELECT * from <<lcTable>>;
>        ORDER BY <<lcTag>> <<lcDirection>>;
>        INTO CURSOR <<lcNTable1>> nofilter
>ENDTEXT
>&lcstrsql

>I have a select statement that is working off of a readwrite cursor that I created. I build the select statement within a Text...endText statement like this: