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 |
|
w_cohen
Starting Member
6 Posts |
 Posted - 2008-01-30 : 16:09:35
|
| For SQL 2000 -I have a column defined as (int, null).The data has an implied decimal.In my SELECT clause how do I see the result with the real decimal point?Thanks.Walter |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2008-01-30 : 16:24:52
|
| there is no decimal with INT data type. not exactly sure what your question is..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
w_cohen
Starting Member
6 Posts |
Posted - 2008-01-30 : 16:48:12
|
| I know there's no decimal with that data type. However, the current data in the column has an implied decimal point and when I do the SELECT I want my result to show the decimal.i.e. column data is 1751The data really is 17.51Thanks.Walter |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2008-01-30 : 17:35:54
|
| I dont understand. why is it 1751 if it should really be 17.51? why wasnt decimal datatype used in the first place?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-01-30 : 20:38:46
|
[code]select yourcolumn / 100.0from yourtable[/code]
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
Implied decimal - how see result with decimal