Hi there,

If your already using the code given byu Gila Monster (:DYOUR THE MAN!), you can add this...

Yeah I know the code I added looks icky but hope it helps

Select NewColumn=CASE

WHEN CAST(LEFT(MyColumn,Len(MyColumn)-1)AS DECIMAL(5,2))<10 THEN '0'+CAST(MyColumn AS VARCHAR(50))

ELSE MyColumn

END

FROM

(

SELECT CAST(CAST(0.10*100 AS numeric(10,2)) AS varchar(5)) + '%' as MyColumn

Union

SELECT CAST(CAST(0.011*100 AS numeric(10,2)) AS varchar(5)) + '%' as MyColumn

Union

SELECT CAST(CAST(0.02*100 AS numeric(10,2)) AS varchar(5)) + '%' as MyColumn

Union

SELECT CAST(CAST(0.12*100 AS numeric(10,2)) AS varchar(5)) + '%' as MyColumn

) MyTable

Order by CAST(Replace(MyColumn,'%','') as DECIMAL) asc