This fixed my problem. I knew it was going to be something easy.

thanks for the information and looking at the problem.

Beth

>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: