>>SELECT * FROM myTable WHERE myCodeField IN ?myCodeVariable and in this particular case

myCodeVariable = "'AAAA','BBBB','CCCC'"

>
>Think you need like this
>
>select * form mytable where (mycodefield in myvariable(1)).or.(mycodefield in myvariable(2)).or. etc
>
That's right, Todd, I implemented this in form of
SELECT * FROM myTable WHERE myCodeField IN ?aCodes(1),?aCodes(2), etc., but it has fixed number of variables, and we were thinking of different number for each REQUERY().

Nick