I have the following query which is pointing to two selecxt statements both the select statements are same bcos, we had a 2 gb problem with the first table so i c reated a new table with 1 to the same name ocrdata.
now i want to get the data and put into Cursor lcSource.

Can you please tell me am i doing it right or not, Please help.
Thank you.
**************************Code**********************************
LcSQL = [select distinct(a.tiffile), b.proj_no, c.docindex_i ];
+[from ocrdata a, docudeck b, docindex c ;
WHERE Upper(a.OCDATA) like "%] + Upper(alltrim(stxtocrstring)) + [%"] + swhere +;
[ order by a.id Union All ];
+[select distinct(a.tiffile), b.proj_no, c.docindex_i ];
+[from ocrdata1 a, docudeck b, docindex c ;
WHERE Upper(a.OCDATA) like "%] + Upper(alltrim(stxtocrstring)) + [%"] + swhere +;
[ order by a.id into Cursor lcSource]

********************************End************************