Cindy,

Ok, that's what I wanted to confirm and what Ed Pikman warned me about.

IN with long lists of codes doesn't work with VFP tables.

Can we consider it as a bug of VFP? From Help I don't have an impression, what this syntax is prohibited...

>Nadya,
>
>I've just done a little testing. Though my process of using IN () with a long string works fine against the SQL database I use, it does not appear to work in VFP6.
>
>
>>Cindy,
>>
>>I've just made a quick test. I opened our Towns table and wrote couple of Town code on the list of paper, then I tried:
>>

>>select * from towns where town in ;   ('AVON', 'BELL','BRAI','CONA','DEDH','MEDV','NORF','PLAI','QUIN','WALE','WSPR','ADAM','EGRE')
>>

>>
>>All these codes are in our Towns table. As you can see, there are 13 codes I wrote. The result, I got, hovewer, contained only 11 records. How can you explain it?
>>
>>Thanks.