Guest Posted August 13, 2006 Share Posted August 13, 2006 I have sporting league tables which have the divisions as 'P' (Premier), '1', '2' and '3'. I have this code installed: ORDER BY division ASC, which puts 'P' at the bottom of the list. How can I put 'P' at the top? (then 1,2,3). Thanks, Wayne. Link to comment Share on other sites More sharing options...
Guest Posted August 13, 2006 Share Posted August 13, 2006 you would have to define a sort order column with that sql table so then you will be able to define the order of the entries and sort them accordingly. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.