> >testString = "Select webprddt6.drawmext3.dmdrawno As f1, prevchng, dwgshts, projengd," +; >" webprddt6.drawmext3.dmcust, jobno1, dm_drawing_title," +; >" (Select itnbr From amflib6.itemasa Where itnbr Like f1" + '%' + ") f2 From webprddt6.drawmext3" +; >" Join webprddt6.drawmstrp On webprddt6.drawmstrp.dm_drawing_number = webprddt6.drawmext3.dmdrawno" +; >" Where projengd = '05/06/2009' Order By webprddt6.drawmext3.dmdrawno" > >I believe you need an inner join where you can have LIKE clause of join. Otherwise I would use either table valued or scalar function (SQL Server).
Select webprddt6.drawmext3.dmdrawno As f1, prevchng, dwgshts, projengd," +; >" webprddt6.drawmext3.dmcust, jobno1, dm_drawing_title, itnbr as F2 " +; >" From webprddt6.drawmext3" +; >" Join webprddt6.drawmstrp On webprddt6.drawmstrp.dm_drawing_number = webprddt6.drawmext3.dmdrawno" +; " JOIN amflib6.itemasa ON itnbr Likewebprddt6.drawmext3.dmdrawno " + '%'" + ; >" Where projengd = '05/06/2009' Order By webprddt6.drawmext3.dmdrawno "Also please use TEXT -ENDTEXT - the code would be much easier to read/test/modify.