Hi Borislav

>You could put comments as many as you wish, but don't use VFP comments chars [* or &&] use SQL Server ones [-- or /* */]
>Something like:
>

>TEXT TO cVar NOSHOW
>     SELECT MyField,    -- This is the first field
>            SecondField -- SecondSelected field
>     FROM MyTable       /* This is the table */
>ENDTEXT
>SQLEXEC(.....)
>

Didn't seem to work. I have tried to paste the query in SQL Query analyser and it would work. But the same (ie. with comments with -- in it) will not work from VFP. Worked only after I removed, unfortunately with the time limitations I couldn't test which one, all the comments.