Sorting a VARCHAR column as FLOAT using the CAST operator

Solution 1

SELECT guid, number FROM table ORDER BY number * 1 DESC

 

Solution 2

...CAST(value as DECIMAL(10,5))