Sorting a VARCHAR column as FLOAT using the CAST operator Solution 1 SELECT guid, number FROM table ORDER BY number * 1 DESC