sql rounding value
- by fishhead
hello, I have been sucsessful at rounding my value to one decimal point but I would like to trim off the multitude oz trailing zeros.
ROUND(SUM(Duration ),1)
ends up giving me
16.9000000000000000
how do I trim all those trailing zeros.
thanks
mssql