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 |
|
toxicrainpx
Starting Member
8 Posts |
 Posted - 2008-02-19 : 13:21:44
|
| Hello, I have a table with a field with the format of 8 decimals. When I make a select to that table instead is given me (for example) 25,00 it gaves me 25,00000000. How can I fix the with the correct format? Thanks in advance. |
|
|
tprupsis
Yak Posting Veteran
88 Posts |
Posted - 2008-02-19 : 16:01:17
|
| Are you wanting to change the data type in the table? Or just display it differently when you select data out of it? |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-02-20 : 00:36:50
|
| Where do you want to show data?You can use select cast(col as decimal(12,2)) from tableMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Help with Decimals