>Hi All,
>
> I know that this has been discussed, but when I searched on this title, none of the results seem to answer my problem. My sql string looks like this:
>

>SELECT &alist[1]&alist[2]&alist[3]&alist[4]&alist[5]&alist[6]&alist[7]&alist[8];
> FROM &cFile_list ;
> WHERE &aConds[1]&aConds[2]&aConds[3]&aConds[4]&aConds[5]&aConds[6]&aConds[7]&aConds[8] ;
>  .AND. &aJoin[1]&aJoin[2]&aJoin[3]&aJoin[4]&aJoin[5]&aJoin[6]&aJoin[7]&aJoin[8] ;
> ORDER BY &cSort_set INTO CURSOR (cTable_name)
>

>
>I am going against native tables. I did not have this problem in vfp6 until now.
>Please help,
>Thanks,
>Beth

Why not:

TEXT TO lcSELECT TEXTMERGE NOSHOW
     SELECT <<alist[1]>>, <<alist[2]>>........
     WHERE <<aCond[1]>><<aCond[2]>>.....
     ORDER BY <<cSort_Set>>
     INTO CURSOR <<cTable_Name>>
ENDTEXT
&lcSELECT