Int / Int does not give decimal value

[flickimp]

Hi

Please help with this:

When I enter

Select 2800 / 1000

I get 2, but I am expecting 2.8

When I enter

Select convert(decimal (9,2),2800/1000)

I still get 2.

What am I doing wrong here?

[movieking81]

Could you use something like this;

Select FormatNumber(28 00/1000,1)

[folderol]

Hi

When I enter
Select 2800 / 1000
I get 2, but I am expecting 2.8 When I enter
Select convert(decimal (9,2),2800/1000)
I still get 2.

What am I doing wrong here?

For SQL, one of the numbers must be numeric. You can solve this for constants simply by expressing them as
select 2800 / 1000.0

for columns you should use

select 2800 / cast( my_integer_colu mn as decimal(10,2))

Tom

[flickimp]

Thanks that helped!