468,242 Members | 1,474 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,242 developers. It's quick & easy.

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
Expand|Select|Wrap|Line Numbers
  1. SELECT ROUND(6.0949997901916504,3)
the outcome is correct

6.0950000000000000

but when I use
Expand|Select|Wrap|Line Numbers
  1. 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!!!
Dec 16 '08 #1
1 2483
ck9663
2,878 Expert 2GB
Use CAST instead

-- CK
Dec 18 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Bob Bryan | last post: by
2 posts views Thread by Yanir | last post: by
1 post views Thread by msnews.microsoft.com | last post: by
6 posts views Thread by dkirkdrei | last post: by
3 posts views Thread by Arie | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.