ORDER BY number/char ??

[Ajit Aranha]

Hi,
I need to order by the numeric value of a char column.
(to get a an order like 1,2,3,4,�10,11 (numeric) instead of
1,10,11,2,3�. (char) )
 
Here is a query which does�nt work which hopefully demonstrates what I�m
trying to do.
 
SELECT * FROM SOME_TABLE   ORDER BY TO_NUMBER(SOME_CHAR_COLUMN)
 
I am using sapdb 7.3 in oracle mode can someone suggest a workaround.
 
Regards,
Ajit