>

>TEXT TO cSqlCommand TEXTMERGE NOSHOW PRETEXT 7
>       select mytable.field1, mytable.field2 from mytable
>       left join mytable2 on mytable.pk = mytable2.pk 
>       where  <<cSomeFilterExpr>> order by field1, field2
>ENDTEXT
>

TEXT/ENDTEXT stores the literal text contained into the variable, try changing your code to ...

TEXT TO cSqlCommand TEXTMERGE NOSHOW PRETEXT 7
select mytable.field1, mytable.field2 from mytable left join mytable2 on mytable.pk = mytable2.pk where  <<cSomeFilterExpr>> order by field1, field2
ENDTEXT