>Is there any optimization difference in the following:
>
>SELECT FIELD FROM TABLE WHERE FIELDDATE=DATE() INTO CURSOR TEMP
>
>OR
>
>ldDate=DATE()
>SELECT FIELD FROM TABLE WHERE FIELDDATE=ldDate INTO CURSOR TEMP

I'm almost sure the 2nd is faster. Also, what happens with the 1st one if the SELECT is executed over midnight?

Vlad