order by 1
"Susan Lam" <susana73hotmail.com> wrote in message
news:7186ed56.0307071524.17448526posting.google.c om...> I have a varchar2 column which stores characters as well as numbers in
> string such as '12345'. I would like to sort the column so that it
> orders by the actual number in the number string. However, if I do a
> simple order by, 111 is smaller than 22. Is there a easy way to
> accomplish this in sql instead of doing in programming?