Hi Michael,

>In a SQL select statement. (original code VFP 5) I came across the code below as part of the WHERE clause
>

>(Empty(?ThisForm.Customer) or  ?ThisForm.Customer= Ordhead.customerid)
>

>
>As stated previously, empty is not rushmore optimizable, therefore how do I change this to return the same info. I am rewriting the queries in VFP 9 and wish to get the same results.
>
>Mike

If your backend was SQL Server, not VFP, interrogation signal (?) will indicate to SQL that variable after the ? is a external variable (eg.: a public variable in VFP). I think that ? in VFP has no effect (I'm not sure, never try this).
If your form's property Customer be a number you can to do this:

(ThisForm.Customer = 0 or  ThisForm.Customer = Ordhead.customerid)

Good luck!