>>I have a table that contains a character field with letters and digits that after a query on this table I want to set the order by the numbers contained on this character field...
>>
>>something like this:
>>as-ds-1-xx
>>as-ds-2-xx
>>as-ds-3-xx
>>as-ds-10-x
>>
>>not like this:
>>as-ds-1-xx
>>as-ds-10-x
>>as-ds-2-xx
>>...
>>
>>that is what ...
>> thanks!!
>
>Select val(substr(mycharfield,7,2)) as dummy,* from mytable order by 1
Thanks once again Edward!!!
Just a little problem, what about if the digit is not all the time at the same possition and also will be different length.. like 10, or 100 or 2034
An Intelligent fool can make things bigger and more complex... It takes a touch of a genius -and a lot of courage- to move in the opposite direction".
-Albert Einstein