or, use

ROUND(YourValue, 1)

(revised) I'm sorry... I meant ROUND(YourValue, 0, 1)

I apologize for my lack of proof-reading.

The non-zero 2nd parameter truncates the value, without changing the datatype.