Re: Select statement with decimals as a record...

2001-12-29 Thread Todd Williamsen
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.mys

Re: Select statement with decimals as a record...

2001-12-29 Thread Steve Rapaport
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

Select statement with decimals as a record...

2001-12-29 Thread Todd Williamsen
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? -