Hi ,

Select * from Table Where Field1="1" And (Field2="2" or Field2="3")

should be faster. But don't forget

Select * from Table Where Field1="1" And Between(Field2, "2", "3")

my gut tip here since it is optimizable and should give vfp
a range to check against.

Select * from Table Where Field1="1" And Inlist(Field2, "2", "3")

which is also optimizable.

HTH

thomas