Tom, it should only be doing that if the column is set up as a string
column (char, varchar). If possible, convert it to a numeric column
(int, tinyint, etc), and the sort order should then be correct.
If not possible, then you might explore use of the CAST function.
Dan
On 9/28/06, Tom Ray [
I'm running into a problem with a ratings script I'm writing. The
overview is that a user can rate an item from 1-10. What I want it to do
is display the highest rated item, with 10 being the highest rating. In
case there are multiple items sharing the same score, the item that has
been rated t