Forums

Sorting high to low issue help

cruser 15 Oct, 2020
In the screenshot below you can see that there columns "Item 1" and "Item 2" have values. Item 2 column does not sort in the proper order as the value 53 is less than 520. How do I get this so that single, double, and triple-digit values sort properly? Item 1 column sorts highest to lowest while Item 2 sorts the results of Item 1 from highest to lowest.



cruser 23 Oct, 2020
1 Likes
Hey thanks, Max! I changed the structure type in those columns from varchar(255) to int(255) and it all lined up perfectly.
You need to login to be able to post a reply.