Round entire column

[antonopn]

Hello there,

In a table, with a field which type is float (lets say MYFLOAT from MYTABLE) I have this value

6.0949997901916504

It it a value that was imported from an excel sheet.

when I use

SELECT ROUND(6.0949997901916504,3)

the outcome is correct

6.0950000000000000

but when I use

SELECT ROUND(MYFLOAT,3) FROM MYTABLE

the outcome is again 6.0949997901916504!

How can I fix this?

I want to round every price in that column!

Thanks a lot!!!

[ck9663]

Use CAST instead

-- CK