>Is there any way to do a wildcard on the tsosan field in the where section? I know that the table field data will not have the 'A" but I still need a match on the part number.
>
>

>
>testconnString= "Select recseq From webprddt7.tsotagtbl" +;
>" Where cono = '225907' And tsosan in('862708-401A','862708-402A','862708-403A'," +;
>"'862708-404A','862709-401A','862709-402A','862711-401A','862712-401A','862714-401A','862715-401A','862716-401A')"
>
>
>

Something like

where ( tsosan  like "8627__-40%" )
  and ( tsosan  not like "%A" )