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 |
|
kamalkishore_in
Yak Posting Veteran
76 Posts |
 Posted - 2001-07-18 : 06:50:19
|
| Hi guys,I tried lots of ways but all fails...I am giving a command like :SELECT ROUND(577.567,0)it is giving the result I want like :578.000but I have a value in Field like : 577567 and I want the result578I tried many ways like :SELECT ROUND((577567/1000),0)SELECT ROUND(CONVERT(DECIMAL(6,3),577867/1000),0)but all gives the result 577.000All in one line is I wanted to divide my INTEGER field by 1000 and wants to get the rounded value.. Waiting for response.. |
|
|
|
|
|
CONVERT DATA TYPE PROBLEM