I am trying to execute the following statement:

select distinct field1, field2 ;
from rawdata ;
where inlist(field2,lcModString) ;
into table mytable

field2 is a 2 character field. lcModString will vary according to which check boxes are chosen on a form. What I am testing it with is a character string of '22','52'. When I replace lcModString in the above select statement with the literal '22','52' I have 1300 records returned. When I run the code above, I have 0 records returned. I have a feeling that the answer here is extrememly obvious, but those tend to be the most difficult problems for me to solve!

TIA for your help.