As far as i know according to mathematics rounding should work as below when rounding number is 5.

```
2.435 => 2.44 (Round Up, if rounding to digit(3) is odd number)
2.445 => 2.44 (Round Down, if rounding to digit(4) is even number)
```

if we do summation all fine,

```
2.435 + 2.445 = 4.88
2.44 + 2.44 = 4.88
```

I'm pretty sure in .Net also rounding works like this.

But in SQL server, 5 is always rounding up which is not correct according to maths.

```
SELECT round(2.345, 2) = 2.35
SELECT round(2.335, 2) => 2.34
```

this results to 1 cent discrepancies in summation of rounded values.

```
2.345 + 2.335 = 4.68
2.35 + 2.34 = 4.69 => which is not correct
```

I have tried this with decimal and money data types.

Am i doing something wrong? Is there a work around for this?

`2.435 => 2.43`

- why? It should be`2.44`

, always.