My guess would be that "ROUND" just rounds the value and does not convert it to a string.
So the type of the value is still a floating point number and the values you get are the closest possible to the rounded values.
Again assuming that ROUND does not create a string, then that is missing from your query.
Cheers,
_





Reply With Quote
Bookmarks