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 |
|
ladiaocb
Yak Posting Veteran
57 Posts |
 Posted - 2004-07-14 : 16:27:04
|
| Please help! I want to return a value with out the decimal point. For example, i return the value .89 but I want it to look like 89. I am trying to return the value as the actual percentage number (i.e. .100 = 100%, .89 = 89%) |
|
|
kselvia
Aged Yak Warrior
526 Posts |
Posted - 2004-07-14 : 18:46:00
|
| select cast ( value * 100 as varchar) + '%' as value--KenYour Kung-Fu is not strong. -- 'The Core' |
 |
|
|
|
|
|
Decimal Places