Re: sorting a nummeric list

Hi Olav: > I have a resultset from MySQL containing a column with integer values. When > I use de ORDER BY statement to sort the rows on these integer values, I get > the following result: > 1 > 10 > 2 > 3 > 30 > 4 This indicates your field was defined as a text type (ie char, varchar, text) not a numeric field (ie int, double). Best solution is to redefine the field. --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y More than just answers. Solutions. (SM) http://www.analysisandsolutions.com/ 4015 7 Av #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409