>BETWEEN somefield XXXX AND YYYY is optimisable command
>If you check I didn't used BETWEEN() function in SELECT (example 3).
>

>CREATE CURSOR crsTest (Fld1 D)
>INDEX ON Fld1 TAG crsTest
>
>SYS(3054,12)
>SELECT * FROM crsTest WHERE Fld1 BETWEEN DATE(2009,1,1) AND DATE(2009,12,31) INTO CURSOR crsTTT
>SYS(3054,0)
>

I know, I just didn't see it in your original message (missed somehow).