SQL ORDER chars numerically

by

Try this:

ORDER BY CAST(thecolumn AS int)

More Related Contents:

  1. Sort by column ASC, but NULL values first?
  2. SQL multiple column ordering
  3. What is the major difference between Varchar2 and char
  4. ORDER BY the IN value list
  5. SQL best practice to deal with default sort order
  6. How to order by with union in SQL?
  7. SQL Query – Using Order By in UNION
  8. Optimize query with OFFSET on large table
  9. How to use DISTINCT and ORDER BY in same SELECT statement?
  10. sql ORDER BY multiple values in specific order?
  11. Sorting null values after all others, except special
  12. How to use SQL Order By statement to sort results case insensitive?
  13. Can I do a max(count(*)) in SQL?
  14. How to update and order by using ms sql
  15. How to ORDER BY a SUM() in MySQL?
  16. SQL Server UNION – What is the default ORDER BY Behaviour
  17. Sort NULL values to the end of a table
  18. SQLite and custom order by
  19. PostgreSQL ORDER BY issue – natural sort
  20. Why do NULL values come first when ordering DESC in a PostgreSQL query?
  21. PostgreSQL: how to convert from Unix epoch to date?
  22. Alphanumeric sorting with PostgreSQL
  23. SQL ORDER BY date problem
  24. “Order By” using a parameter for the column name
  25. Custom Order in Oracle SQL
  26. SQL for ordering by number – 1,2,3,4 etc instead of 1,10,11,12
  27. SQLite Order By Date1530019888000
  28. how does SELECT TOP works when no order by is specified?
  29. How to get results in a custom order? [closed]
  30. Dynamic order direction

Leave a Comment