SELECT round( 35.25 TO 1),
       round( 35.15 TO 1)
FROM AnyTableYouWant

returns [35.3, 35.1]

---

 Comments and Workarounds

---

The only way to solve this rounding issue is to cast the constants as Decimal(0,2), since this is a floating-point issue caused by the internal base-2 structure of floating-point numbers.

---

 Resolution

---

Cannot Fix Problem