Posted by yellow1912 on 09/08/05 21:52

Thanks a bunch!!!

But I ran into this:
For example I have a column "NAME" contains name:
Name 1
Name 2
.....
Name 99

If I ORDER BY NAME DESC I will get something like this:
Name 99
Name 98
......
Name 90
Name 8 //The problems is here
Name 89
Name 88
......

The problem, I believe, is because of the way mysql compares the
strings. Hence make this sort kinda weird! How can I fix this, any
walk-around?

[Back to original message]