Not much different.

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,
>
>Thanks for the tip, works great. But what would the Select statement look like if I wanted to filter on the datetime field with the below line?
>
>[AND sales.order_date = TO_DATE('] + mydate + [', 'MM/DD/YYYY') ]