calculation within a select satement

[MrDontKnowNothing]

hi folks,

i'd like to do some calculations within a query, but the result is only a integer value but i need something like a float.

select (value / 100 + value) as newvalue from mytable

any help appriciated...thanx!

alex

 

[bs26]

Cast the value as float to get a result in float

Here:
select ( cast( value as float) / 100 + value) as newvalue from mytable


Bobby

 

[JamesLean]

Try:

SELECT value / 100.0 + value AS newvalue
FROM mytable

--James

 

[MrDontKnowNothing]

that was pretty good, but how to provide a usefull prevision?

cheers

alex

 

[SQLBill]

What do you mean by "how to provide a usefull prevision?"

-SQLBill

 

[MrDontKnowNothing]

sorry, i meant "precision".
in other words: how to make it look like "3131,85"

cheers

alex

 

[swampBoogie]

SELECT cast(value / 100.0 + value as decimal(6,2)) AS newvalue

 

[MrDontKnowNothing]

thank you guys!

cheers

alex