Barbara,
The field has to be on the left to be rushmore optimizeable.
>And this is directly opposite to the thread from a week or two ago that said the field MUST be on the left to work reliably. Very strange.
>
>>Interesting. In 5.0aw/sp3, I tried this and some variations, too.
>>
>>x={^1998/10/27 08:30:00 A}
>>SELECT * FROM c_tbl WHERE x = dt_tm && This selects the correct record
>>SELECT * FROM c_tbl WHERE dt_tm = x && This results in an empty data set.
>>
>>>SELECT * FROM c_tbl WHERE dt_tm = {^1998/10/27 08:30:00 A}