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