SELECT ROUND(MyColumn - 0.01, 0) FROM MyTable
DECLARE @Num DECIMAL(18,2) = 1.4 SELECT ROUND(@Num,0)
SELECT ROUND(columnname,0) AS RoundedPrice FROM tablename;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)