RE: Order issue with MySQL

2002-11-13 Thread LAMARTS
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]] >>

Re: Order issue with MySQL

2002-11-13 Thread Jocelyn Fournier
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

RE: Order issue with MySQL

2002-11-13 Thread Cooke, Francis
> -- > 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

Order issue with MySQL

2002-11-13 Thread LAMARTS
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