> >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" )