Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dprichard
Yak Posting Veteran
94 Posts |
 Posted - 2008-01-31 : 15:55:07
|
| I have a query and it pulls in the results of 652,174 / 5,000,000 as .1304 when it is actually .1304348. How can I force it to show the additional numbers. For my reports to be accurate it has to show the full .1304348.Thanks for any help in advance. |
|
|
jdaman
Constraint Violating Yak Guru
354 Posts |
Posted - 2008-01-31 : 16:05:52
|
| SELECT CAST(652174 AS FLOAT) / 5000000 |
 |
|
|
dprichard
Yak Posting Veteran
94 Posts |
Posted - 2008-01-31 : 16:15:35
|
| Awesome... I was actually just reading about float when your email came in. That worked perfectly. Thank you so much for the quick answer!!! |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-02-01 : 10:41:05
|
| orSELECT 652174.0 / 5000000MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Math not showing all numbers after the decimal