Help with sorting... please.. :)

[Sarah]

I'm trying to sort the output of a query.. and I know you can use the
"order by" clause, but it doesn't work the way I want it to.

I'm trying to sort a list of prices, but when I do it gives me
something like this:

1.15
11.25
2.29
205.79
5.99
529.95

How can I make it so it actually goes from lowest to highest priced?

Thanks in advance!

Sarah

[Ken Schaefer]

It appears that you are storing the values in some kind of text field (which
would explain the ordering), since 200 comes before 5 in such a case.

Change the field type in your database to "decimal", or whatever your
database calls it.

Cheers
Ken

"Sarah" <saralicious@/nospam/hotmail.com> wrote in message
news:te4nhv8f83o2aakuggh1bcdtilr7so52cc@4ax.com...
: I'm trying to sort the output of a query.. and I know you can use the
: "order by" clause, but it doesn't work the way I want it to.
:
: I'm trying to sort a list of prices, but when I do it gives me
: something like this:
:
: 1.15
: 11.25
: 2.29
: 205.79
: 5.99
: 529.95
:
: How can I make it so it actually goes from lowest to highest priced?
:
: Thanks in advance!
:
: Sarah
: