Hi Walter,

You're right in general but SQL BETWEEN operator is optimizable regardles of using NOFILTER or not.

>Sergey,
>
>Watch out for filtered resultsets. You might want to add NOFILTER to the SQL select.
>
>Walter,
>
>>>>>Torgny,
>>>>>
>>>>>I don't know if (SQL) BETWEEN is optimizable. Apparently, BETWEEN() (the function) *is*.
>>>>
>>>>Yes, it is.
>>>
>>>Good to know. Have you got a reference so that I can write another Documentation note to MS about this being documented in the CORRECT place?
>>
>>I know it from my expirience but following test confirms it

USE (HOME(2) + "\Tastrade\data\orders")
>>SYS(3054,11)
>>SET DELETED OFF
>>SELECT * FROM orders ;
>>	WHERE order_id BETWEEN "    25" AND "    40" ;
>>	INTO CURSOR crsTemp

>>