مرتب کردن اعدا در یک فیلد غیر عددی

[محمد سلیم آبادی]

SELECT TOP 1 * FROM table_name ORDER BY column_name + 0 DESC

SELECT TOP 1 * FROM table_name ORDER BY LEN(column_name), column_name DESC

SELECT TOP 1 * FROM table_name ORDER BY CAST(column_name AS INT) DESC