lc_custno = [123] lc_date = '07/01/2004' TEXT to lc_SQL TEXTMERGE NOSHOW PRETEXT 3 && you may not have pretext option SELECT * FROM MyOracle.Sales Sales WHERE Sales.customer = ?lc_custno AND Sales.OrderDate = TO_DATE('<<lc_date>>', 'MM/DD/YYYY') ORDER BY Sales.OrderDate ENDTEXT *!* get rid of line returns [not needed in VFP9 BTW] lc_SQL = STRTRAN(lc_SQL, CHR(13) + CHR(10), [ ]) nresult = SQLEXEC(myhandle, lc_SQL, 'myresults')>Mark,