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]]
>>
Hi,
perhaps try :
ORDER BY SUBSTRING_INDEX(your_field, '-', 1) asc,SUBSTRING_INDEX(your_field,
'-', 2) asc,SUBSTRING_INDEX(your_field, '-', 3) asc;
Regards,
Jocelyn
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 13, 2002 4:38 PM
Subject
> --
> 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
