Hi David,

>I never heard it had to be on the left, only it had to exactly match the tag expression.

I always put the field on the left side, because it used to be this way in earlier versions, but the help file (VFP 6 in this case) states:

"A basic optimizable expression takes one of the two following forms:

eIndex relOp eExp

-or-

eExpr relOp eIndex"

Therefore, it's either a bug in the product, or a bug in the documentation, I vote for the first one. But it could be related to your use of the SQL engine. SQL's Rushmore behaves differently in a number of way compared to xBase's Rushmore. Perhaps, the above is only valid for the xBase Engine.

Christof