Re: Sorting issue

"Jeff" <jroth1@telus.net> wrote in message news:20030808144422.41954.qmail@pb1.pair.com... > Why would a mysql db think that 55 was greater than 14000. > > I have several headings that display sql data under them, when you click on > the heading, it sorts that section (descending/ascending), but it only seems > to be looking at the first two numbers in the one heading. Is there a > command that forces it to look at the entire record before sorting it? Because "55" is greater than "14000"... i.e. you're sorting the values as strings, not integers. ---John Holmes...