select 3/4

• Sachin Butala-182900

  SSC-Addicted

  Points: 406

  More actions

  March 31, 2008 at 1:31 am

  #379510

  HELLO,

  trying to fetch float value .75 but select 3/4 always give me 0, any idea how to achive this.

  thanks and Regards

  sachin

• antonio.collins

  SSCrazy Eights

  Points: 9600

  More actions

  March 31, 2008 at 11:02 am

  #796062

  integer division always results in integers. cast one term to float to get a float.

  select cast(3 as float)/4