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