It was Sylvain who caught the problem I just sugested different way to fix it. :)

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