How to skip rounding the number in sql server

Question

Hi All

DECLARE@count NUMERIC(8, 2) 
set @count = 165.165 
print @count

Result is giving '165.17' where as i need '165.16'

it should not round of the number

please help

Answer 1

Answer by Kev Riley · Jan 21 at 01:06 PM

You need to explicitly truncate the number using the 3rd argument in the ROUND() function

declare @count NUMERIC(8, 2) 
set @count = round(165.165,2,1)
print @count

165.16

2 · Share