Hi Steven,

Try this...

mysql = "Select recseq, partno, dwgrev, dwgtitle, faistatus, engno From webprddt7.drawmfai" +;
" Left Join amflib7.itemasa On amflib7.itemasa.itnbr LIKE CONCAT(webprddt7.drawmfai.partno,'%')" +;
" Where rectype = ?recType  And failocn = ?location" + isFilter

MartinaJ

>I always have a SPT issue.
>
>In the following SQL when the webprddt7.drawmfai partnumber matches the amflib7.itemasa.itnbr exactly it works great. But sometimes the part number in the webprddt7.drawmfai is without any suffixes(base number such as 899999-001) while the itnbr in the amflib7.itemasa has 899999-001A etc. I would still like to return the amflib7.itemasa.engno when this semi match exists.
>
>Thanks for all the help.
>
>

>
>mysql = "Select recseq, partno, dwgrev, dwgtitle, faistatus, engno From webprddt7.drawmfai" +;
>" Left Join amflib7.itemasa On amflib7.itemasa.itnbr = webprddt7.drawmfai.partno" +;
>" Where rectype = " + recType + " And failocn = " + location + isFilter
>					
>
>
>