Hi there... agian,

Remember the icky code I added to Gila Monster and Dugi's code? We'll I made it a less icky but if your already using Gila's code, you need a few modifications for this one

Select NewColumn=CASE

WHEN MyColumn<10 THEN '0'+CAST(MyColumn AS VARCHAR(50))+'%'

ELSE CAST(MyColumn AS VARCHAR(50)) +'%'

END

FROM

(

SELECT CAST(0.10*100 AS numeric(10,2)) as MyColumn

Union

SELECT CAST(0.011*100 AS numeric(10,2)) as MyColumn

Union

SELECT CAST(0.02*100 AS numeric(10,2)) as MyColumn

Union

SELECT CAST(0.12*100 AS numeric(10,2)) as MyColumn

) MyTable

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

Oh... and sorry for my bad English, Hope my code also helps ^__^