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 |
|
skybvi
Posting Yak Master
193 Posts |
 Posted - 2011-03-25 : 12:12:30
|
| hi, How to round of hte values in 1 column..I have values in a column, for ex...18.544398, I want 18.54 ( rounded off 2 decimals)The datatype iam using for tht coulmn is float..Thanks.Regards,SushantDBAWest Indies |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-03-25 : 12:41:34
|
| [code]round(YourColumn,2)[/code] |
 |
|
|
skybvi
Posting Yak Master
193 Posts |
Posted - 2011-03-25 : 14:54:23
|
| wow, it was so easy..thanks a lot !!Regards,SushantDBAWest Indies |
|
|
|
|
|
|
How to round off values in a column