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
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