Thanks for the reply.
I'm not clear on the solution?
--- Original Message ---
From: "Cooke, Francis" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: RE: Order issue with MySQL
>> --
>> From:[EMAIL PROTECTED]
[SMTP:[EMAIL PROTECTED]]
>>
Sent: Wednesday, November 13, 2002 4:38 PM
Subject: Order issue with MySQL
> Hello All,
>
> Using MySQL for sql...webpage forms:
>
> I am trying to order the following:
>
> 1-03-0A0019-03-0D004;
>
> this works fine using simple "order by asc".
>
> when I
> --
> From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]]
>
> Hello All,
>
> Using MySQL for sql...webpage forms:
>
> I am trying to order the following:
>
> 1-03-0A0019-03-0D004;
...
> when I added 11-02-0B001, etc. it came after "1-03-
> 0D004, then continued to rest
Hello All,
Using MySQL for sql...webpage forms:
I am trying to order the following:
1-03-0A0019-03-0D004;
this works fine using simple "order by asc".
when I added 11-02-0B001, etc. it came after "1-03-
0D004, then continued to rest of order.
how do I fix this so that 11-xx-xxx comes afte