OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Order by a number not leading in zero

From: Scott Haneda (listsnewgeo.com)
Date: Thu Nov 13 2003 - 17:34:17 CST

I have the following...

tSql = "SELECT l.team, l.link, lc.category, l.age, l.date
        FROM league AS l
        INNER JOIN league_category AS lc
        ON l.category = lc.id
        WHERE lc.id = " & prepSQL(tConn, id) & " AND l.status = '1'
        ORDER BY l.age, l.date";

L.age has data in it as varchar() where there are some without a leading
zero.

Rsults end up like
10U
11U
12U
5U
6U
7U

I would like to order those as
5U
6U
7U
10U
11U
12U

Thanks for the help.

--
-------------------------------------------------------------
Scott Haneda Tel: 415.898.2602
http://www.newgeo.com Fax: 313.557.5052
scottnewgeo.com Novato, CA U.S.A.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql