>>>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
Fred gave you correct explanation. I hope you may provide that numeric part will always start with the same position.
Edward Pikman
Independent Consultant