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
Hello bbtresoo,
What do you want as the end result? For example what would you convert 1234ABCD567 to?
-Cognos810
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