Replacing 0 column

• Hatim Ali

  Old Hand

  Points: 325

  More actions

  August 13, 2004 at 3:49 am

  #108967

  Hi,

  Query:

  Select

      Colum1,

      Column2,

      Column1/Column2

  From

      SampleTable

  Problem:

  There may be zero in column1 or column2 or both. Now i want the third column in result set (Column1/Column2) to be zero if either or both columns have ZERO. How can i achive this in a single query.

  Thanks,

  Hatim Ali.

• conrad coetzee

  SSC Enthusiast

  Points: 112

  More actions

  August 13, 2004 at 4:17 am

  #518826

  select Colum1,Column2,

  case

  when Colum1 = 0 then 0

  when Column2 = 0 then 0

  else Colum1/Column2

  end as Colum3

  from SampleTable