Hi Steven,

- db2 doesn't support using functions in ORDER BY?
- partno is datatype number or char/varchar?


MartinaJ

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