Re: order by text

From: Ed Prochak <>
Date: Wed, 13 Feb 2008 18:23:16 -0800 (PST)
Message-ID: <>

On Feb 13, 9:49 pm, C-man <> wrote:
> Hi,
> I have a variable field of type varchar2 called storeId. I need to
> sort the store Id's but they are of variable length and some of them
> contain characters and digits while others contain only digits. I
> tried using order by lpad(storeId, 10) asc but it does not work in the
> case that 1 id is a11 and another one is b2. It gives me b2 and then
> a11.
> Is there a way to fix this?
> Thank you

Assuming you are using an ASCII based character set, space comes before the letters so ' b2' comes before 'a11' (even before 'b11').

Try RPAD() ?

  ed Received on Wed Feb 13 2008 - 20:23:16 CST

Original text of this message