David,
Quite true, BETWEEN includes both end points. Guess I didn't read your code carefully enough.
Barbara
>Barbara,
>
>I was going to test that to see, I just hadn't gotten to it yet. As long as BETWEEN is inclusive of the beginning point and exclusive of the end point, which I kind of doubt, I'd bet it is inclusive of both endpoints. And in this case that's significant.
>
>>I've found that the indexed field (or expression) MUST be on the left for Rushmore to work correctly. In your case could you have used a BETWEEN construction?