Convert String (with mixed letters and digits) to number

[bbtresoo]

Hi guys,

Is anyone can help me on conversion issue. I'm trying to convert a string containing letters and digits (that's the complexity  :-[) to number. Thanks in advance

Data Base : Oracle
Cognos : 10.2.1

[cognos810]

Hello bbtresoo,
What do you want as the end result? For example what would you convert 1234ABCD567 to?

-Cognos810

[bbtresoo]

actually I have a list containing Secu ID(string with mixed letters , digits) , Market Value(number). I 'm ranking on Market value and It works fine. It turns out I have similar Amount so similar ranking as result for different Secu ID. But But I doesn't want same Rank in my list, So I'm looking for another criteria to make a distinction to determine the first , that's why I want to convert Secu ID in number and rank it also, Is it just a thought don't know if it's a good way to get ride of my duplicate rows. Hope I've been more clear, thank you for responding so quikly