Decimal Calculation

[lah3233]

I've got a programmer trying to use this statement...

Select 3/8

..and have it return the decimal value of 0.375

Right now it returns the value of 0.

Can anyone help me get this return the correct value??

 

[ClaireHCM]

just do select 3./8

if you want to modefy little
select cast((3./8) as decimal(6,3))

 

[JamesLean]

select 1.0 * 3 / 8

--James

 

[JamesLean]

Sorry, bit daft:

SELECT 3.0 / 8

--James