SELECT certno, t1.stockplanid, ; ... PADL(ALLTRIM(t1.certno),10,'0') AS certnoord ... ORDER BY planid,certnoord>Thanks for the reply. However, I must be doing something wrong or perhaps have not given enough info. Below is the SQL statement I am using:
>SELECT PADL(VAL(t1.certno),10,'0') AS certno,t1.stockplanid,; > t2.planid AS planid FROM certlog t1 ; >LEFT JOIN Values t2 ; > ON ALLTRIM(t1.stockplanid) = ALLTRIM(t2.id) ; >INTO CURSOR curCert1 ORDER BY planid,certno >>
>Certno StockPlanid Planid >0000010.00 1 1 >0000100.00 1 1 >0001000.00 5 1 >0001002.00 5 1 >0001003.00 5 1 >0000101.00 1 1 >0000102.00 1 1 >0001021.00 5 1 >>
>Certno StockPlanid Planid >0000010.00 1 1 >0000100.00 1 1 >0000101.00 1 1 >0000102.00 1 1 >0001000.00 5 1 >0001002.00 5 1 >0001003.00 5 1 >0001021.00 5 1 >>