>I am trying to execute the following statement:
>
>select distinct field1, field2 ;
> from rawdata ;
> where inlist(field2,<b>&</b>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.
See change in bold
If it's not broken, fix it until it is.
My Blog