SQL CASE drops precision

[Shawn61]

Hi All,

The CASE function appears to lose precision. Some contrived examples:

[FONT=courier new]Expression                                  Result      Expected
---------------------------------------------    ---------    ------------------------
case when 1=1 then 1.234 else 2.345 end           [COLOR=#ff0000]1    [/COLOR]       1.234

cast( case when 1=1 then 1.234 
     else 2.345 end as numeric(15,4) )            [COLOR=#ff0000]1.0000[/COLOR]      1.2340

1.2345+0                                          1.2345      1.2345
[/FONT]

This is using the MERANT driver against Progress 9.
Does anyone know of a fix?

Thank you.