SQL-2005 Rounding Issue...

[Jayanti Patel]

Hi All,

Issue: In SQL Server 2005.

Round (2.5) will give -3
Round (-2.5) will give -3

But in Reality the -3 need to be -2.

how can we make a custom round function that gives the correct result.


Thanks,
Jayanti Patel.

[kenobewan]

Welcome to the site. I'm not sure which reality you are talking about - I believe .0, .1, .2, .3, .4 round down while .5, .6, .7, .8, .9 round up. If you want to create a custom rounding feel free.