Try
select field
from table
order by length(field),field
"Andreas Koch" <mail_at_kochandreas.com> wrote in message
news:aa9e2p$m1h$04$1_at_news.t-online.com...
> Hi,
>
> is there a way to make oracle sort a varchar column in Format TextNumber
> (e.g. Example01, Data42, etc) allways as "Text as Text and
> Number as Number" ?
> (e.g
> Data1
> Data2
> Data9
> Data10
> Error1
> Error5
>
> instead of
>
> Data1
> Data10
> Data2
> Data9
> Error1
> Error5
> )
>
> If this can't be done per connection, what would be the best
> way to modify a SQL to sort this way?
>
> --
> Andreas
> if ((sex==fem)&&(hobby==comp)&&(age~25)&&(status==single)
> &&(cntry=GER)) goto http://www.kochandreas.com/home/single.htm
>
Received on Thu Apr 25 2002 - 20:38:51 CDT
