> where
> Field1 in (1,2,3) and
> Field2 in (1,2)
>

I think this should return the same result:

where
((Field1 = 1) or (Field1 = 2) or (Field1 = 3)) and
((Field2 = 1) or (Field2 = 2))


I'm not sure how fast this method is...


Regards,
Primoz