"Absoulte" sorting?

Hi all,

        I have a question about Oracle sorting. Say I have a colume with varchar2 data type, and there are 3 rows under it. They are abc11
abc2
abc123

After sorting, Oracle gives
abc11
abc123
abc2

Is there a way to sort the colume and makes it abc2
abc11
abc123

I know I can solve the problem by putting the leading 0, but unfortunately, our clients don't want that.
Any help will be appreciated.

--
Vito Kwan
vkwan_at_dorsai.org

===========================================================================
      "I am Sir Oracle, And when I ope my lips, let no dog bark!"
                
                           -William Shakespeare: _The_Merchant_of_Venice_