> >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')" > > >Steven,
text to m.lcSQL noshow Select recseq From webprddt7.tsotagtbl Where cono = '225907' And (tsosan LIKE '862708-401%' or tsosan LIKE '862708-402%' or ...) endextIf not then sending those values to SQL server and creating a table variable is a better solution IMHO. ie:
Text to lcSQL noshow DECLARE @myVals TABLE (VALUE VARCHAR(20)) INSERT @myVals ( VALUE ) VALUES ('862708-401') INSERT @myVals ( VALUE ) VALUES ('862708-402') -- ... Select recseq From webprddt7.tsotagtbl inner join @myVals ON tsosan LIKE [@myVals].VALUE+'%' Where cono = '225907' endtext SQLExec(m.handle, m.lcSQL)If your list is very long then you could also go for a better performing 'send comma separated list and parse to table on server' approach.