>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