Russell,

I amended my code in my second message to you because it wasn't correct. Try

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
>

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