>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

Hi Michel,

This is one I wondered about for a while. After some testing, I get about at 8% speed improvement with the second one.


BFN,
Darrel