>>>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

then use code to construct the select statement

v='select * from mytable where mycodefield in '
for x=1 to numneeded
v=v+'?acodes('+alltrim(str(x))+'), '
next
v=substr(v,1,len(v)-2)
&v

should do it

HTH