Divide not returning decimal values 2

[handle87]

Hi..
When I divide and the result is a decimal I am getting 0 returned instead of the decimal number...

CASE
  WHEN a.PricingStr <> 'PreP' THEN
    21/31
  ELSE
    20/10
END As Total

I am real new to this.. any ideas why I am geting 0 returned instead of the decimal number?

 

[DotNetGnat]

use convert() or cast() function...

-DNG

 

[gmmastros]

CASE
  WHEN a.PricingStr <> 'PreP' THEN
    21.0/31.0
  ELSE
    20.0/10.0
END As Total

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[handle87]

Thank you both... I had tried the CAST before but it did not work... but it was in the wrong area.. as there is more code than what I type.. however, from both of your posts, I got put on the right track and have solved the problem.

Thank again!!