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