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.