When i specify an order by in my SQL and I want to order numbers ASC. Is there a way to make the numbers sort 1,2,3,4 etc. instead of 1,10,11,2,22,23 without leading zeros, ie 01,02,03 etc.
well, yeah. by making sure the field is a numeric datatype and not a string. (!)<BR><BR><BR><BR>
Field has to contain letters and numbers