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 |
|
rjackman1959
Yak Posting Veteran
60 Posts |
 Posted - 2009-01-31 : 14:17:17
|
I have a select that I call from Excel that pulls in rates for orders and I need to change the output to send to a customer. Is there a way I can change the field length of my_rate len 5,4now #.####change to len 8,6show ########with no decimal sign |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-31 : 16:00:13
|
Huh?Make a calculated column which multiplies the my_rate value 10,000 times.Or cast the column value on the fly in your query.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
rjackman1959
Yak Posting Veteran
60 Posts |
Posted - 2009-01-31 : 16:26:17
|
| Thanks Again Peso |
|
|
|
|
|
|
Change field length