sorting numbers stored in text field in MYSQL database

xbjsctsfjnu

New Member
i have a mySQL database with a text field in which is stored a number.i need to produce a recordset sorted in descending numerical order.this works fine until we get to numbers greater than 10 ie 98765432101is there a simple way of sorting this 'correctly' ?(yes, i know i should have numbers in a numerical field, but i'm working with what i have :))i'm using the results on an asp/vbscript/jquery page so maybe even a client-side solution is viable...any suggestions?
 
Back
Top