I found an easier way... switch the datatype to decimal, WHAMMO!! works beautifully! ----- Original Message ----- From: "Steve Rapaport" <[EMAIL PROTECTED]> To: "Todd Williamsen" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, December 29, 2001 7:03 PM Subject: Re: Select statement with decimals as a record...
> Todd, this result is perfectly correct if they are both strings: > > "52.50" is greater than "358". To make them interpreted as > numbers instead, see the manual page: > > http://www.mysql.com/doc/C/o/Comparison_Operators.html > > Steve > > Todd Williamsen wrote: > > > I have a record that keeps track of averages, now when I say > > > > SELECT * FROM tblname ORDERBY 'average' DESC; > > > > It returns the one with the largest amount of intergers... > > > > I.E. > > > > It will say that 52.50 is a larger number than 358, why is that? Is that a > > table column setting of a datatype? > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > -- > Steve Rapaport > World Citizen > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php