>The following db2 SPT gives results like:
>
>861407-401
>861407-401A
>861407-401E
>861407-402B
>861407-402E
>
>Each record has a datestamp field. I need the records ordered by part number(without the suffix), datestamp
>
>

>
>sql = "Select recseq, partno, dwgrev, dwgtitle," +;
>" faistatus, engno, failocn, datstmpi From webprddt7.drawmfai" +;
>" Left Join amflib7.itemasa On amflib7.itemasa.itnbr = webprddt7.drawmfai.partno" +;
>" Where " + luField + luString + " Order By partno, datstmpi DESC"
>
>

If db2 does not allow ORDER BY LEFT(PartNo,6) then include this as a computed field in the field list and use new name in the order by.