Debra do the following
select distinct field1, field2 ;
from rawdata ;
where inlist(field2,&lcModString) ;
into table mytable
>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.
Alexandre Palma
Senior Application Architect