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 after

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 of order.

Re: Order issue with MySQL

2002-11-13 Thread Jocelyn Fournier
: 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 added 11-02-0B001, etc. it came after 1-03- 0D004, then continued to rest of order. how do I fix

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]] Hello All, Using MySQL for sql...webpage