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