SELECT ROUND(2333.7, 0)As '0.7', ROUND (2333.4,0) as '0.4'
0.7 0.4 2334.0 2333.0
select convert(int,round(2333.49,0))as '2333.49',convert(int,round(2333.50,0))as '2333.50'
2333.49 2333.50 2333 2334
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)