1> -- Cast 2.78128 as an integer: 2> 3> SELECT CAST(2.78128 AS integer) 4> GO ----------- 2 (1 rows affected) 1>