By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,806 Members | 1,829 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,806 IT Pros & Developers. It's quick & easy.

Round entire column

antonopn
P: 42
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
Share this Question
Share on Google+
1 Reply


ck9663
Expert 2.5K+
P: 2,878
Use CAST instead

-- CK
Dec 18 '08 #2

Post your reply

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