SELECT * FROM MyTable ORDER BY CAST(amount AS Numeric(10,0)) DESC
SELECT * FROM Table1 Order by CASE WHEN CHARINDEX('.',COL1) > 0 THEN CAST(SUBSTRING(Col1,1, CHARINDEX('.',COL1)-1) AS int) ELSE COL1 END
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)