i have designed a table which contains varchar2 fields.

one of these fields contains decimal data.

i want to sort this table with this field using the caracteristics of the decimal data, not the string caracteristics because the sort order is not the same.

i intend to use the function TO_NUMBER(a,b) but i do not know how to use the 'b' statement to set up decimal caracteristics.

Could anybody help me ?

Thanks in advance.

best regards.