How do I sort a VARCHAR column in SQL server that contains numbers?

by

One possible solution is to pad the numeric values with a character in front so that all are of the same string length.

Here is an example using that approach:

select MyColumn
from MyTable
order by 
    case IsNumeric(MyColumn) 
        when 1 then Replicate('0', 100 - Len(MyColumn)) + MyColumn
        else MyColumn
    end

The 100 should be replaced with the actual length of that column.

More Related Contents:

  1. How to create a specific SQL Server stored procedure? [closed]
  2. SQL Server dynamic PIVOT query?
  3. SQL Server – Best way to get identity of inserted row?
  4. Should I use != or for not equal in T-SQL?
  5. How to update two tables in one statement in SQL Server 2005?
  6. SQL Server Process Queue Race Condition
  7. Create a date from day month and year with T-SQL
  8. How should I pass a table name into a stored proc?
  9. Is the NOLOCK (Sql Server hint) bad practice?
  10. SQL – Subtracting a depleting value from rows
  11. How to set variable from a SQL query?
  12. SQL Server SELECT to JSON function
  13. How to count instances of character in SQL Column
  14. Sequence vs identity
  15. Dynamic update statement with variable column names
  16. How to select only the first rows for each unique value of a column?
  17. SQL Server (TSQL) – Is it possible to EXEC statements in parallel?
  18. Count Returning blank instead of 0
  19. Unordered results in SQL
  20. Using PIVOT in SQL Server 2008
  21. How to find column names for all tables in all databases in SQL Server
  22. Generating random strings with T-SQL
  23. SQL Row_Number() function in Where Clause
  24. ORDER BY items must appear in the select list if SELECT DISTINCT is specified
  25. How do I compare 2 rows from the same table (SQL Server)?
  26. SQL – How do I get only the numbers after the decimal?
  27. How to retrieve records for last 30 minutes in MS SQL?
  28. Group consecutive rows of same value using time spans
  29. Why do SQL Server Scalar-valued functions get slower?
  30. Previous Monday & previous Sunday’s date based on today’s date

Leave a Comment