select cast(10.3333 AS DECIMAL(10,2)) Result -- 10.33 select cast(10 AS DECIMAL(10,2)) Result -- 10.33 select cast(your_float_column as decimal(10,2)) from your_table