>Hi,
>
>Can someone give more information on the error 'String too long to fit'
>How can I resolve this?
>
>Thank you.
>
>Ria

Try with TEXT ... ENDTEXT

Ex:

TEXT TO lcCmd NOSHOW
 SELECT Field1, Field2, Field3, ...
 ... 
 FROM MyTable 
 ORDER BY Field1 
 INTO CURSOR MyCursor
ENDTEXT
lcCmd = CHRTRAN(lcCmd, CHR(10)+CHR(13), " ")
? LEN(lcCmd)
? lcCmd
*-- or
&lcCmd