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 |
|
vk18
Posting Yak Master
146 Posts |
 Posted - 2007-04-02 : 17:30:17
|
| Hi guys,I have a ActualRate In the Data Base table as '575' but when i export it to a text file i am getting like "575.0000".How to eliminate .0000 from that. Appreciate your helpI am using Vb.Net/Asp.Net and SqlServer2000Thx |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-04-02 : 18:07:06
|
| how are you exporting it? You can use the CAST or CONVERT function to get rid of the 0's. If you want to round it you can also use the FLOOR or CEILINg functions.************************Life is short. Enjoy it.************************ |
 |
|
|
|
|
|
currency Format