Posted by muldoonaz on 09/08/05 21:59

yellow1912 wrote:
> 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?
>

add a 0 to the 8 so it shows 08 in the DB. That'll make it order them
right.

[Back to original message]