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 |
|
chad
Starting Member
11 Posts |
 Posted - 2006-04-27 : 12:03:39
|
| Hey everyone,Trying to figure out how I can maintain 4 decimal places in my output? For example, if the value contained in a column is 9.3000, how can I get the output to read 93000?select convert(int,PrbPay*100) as payrate...... |
|
|
noamg
Posting Yak Master
215 Posts |
Posted - 2006-04-27 : 12:13:57
|
| if i understand, just select col * 1000Noam Graizer |
 |
|
|
chad
Starting Member
11 Posts |
Posted - 2006-04-27 : 12:39:58
|
| thanks...not sure what I was thinking :) |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-04-28 : 01:50:25
|
Madhivanan, you have a good memory 
KH |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-04-28 : 01:54:04
|
quote:
Originally posted by khtan
Madhivanan, you have a good memory
KH
Yes. I think so MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
filling decimal places