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 |
|
kwikwisi
Constraint Violating Yak Guru
283 Posts |
 Posted - 2008-07-01 : 02:19:31
|
| I have one field and type is float.I want to retreive with decimal places.It's ok if value is like 12.4,but i want 23.00 if value is 23. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-01 : 02:22:12
|
| Cast it to float and try. |
 |
|
|
kwikwisi
Constraint Violating Yak Guru
283 Posts |
Posted - 2008-07-01 : 02:28:30
|
Pls let me know how to do it? Data type is already float.Thanks.quote:
Originally posted by visakh16
Cast it to float and try.
|
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-07-01 : 16:48:27
|
| Cast(col as decimal(16,2))MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Decimal format?