Michel it is always best to take functions out of a loop is possible - and in this case the SELECT serves as a loop (i.e. the DATE() function is re-evaluated for every record) thus the second statement runs faster Arnon > >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 >