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
[EMAIL PROTECTED] Novato, CA U.S.A.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
