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
where certno is the field in question. This is a sample of the results:
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
What I want is:
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
Hope this clarifies things abit.
Thanks again,
Russell