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 |
|
osirisa
Constraint Violating Yak Guru
289 Posts |
 Posted - 2008-02-04 : 16:42:12
|
| Hi Group:Ok, I need help in elimnating the extra numbers after the decimal point. For example this is what I am getting right now(-0.0502635627544488) and I need (-0.050)Any ideas....Thanks |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-02-04 : 17:32:48
|
[code]convert(numeric(12,3),round(MyNumber,3))[/code]You need to decide if you want 2 or 3 decimal places. CODO ERGO SUM |
 |
|
|
|
|
|
Need Help on how to create only 2 decimal places