round - Rounding down decimal numbers in SQL Server 2008 ...

I read all rounding functions of T-SQL like Round,Floor,Ceil ... 1) select CAST( FLOOR(2 * 3.69) / 2 AS ...

stackoverflow.com