CAST problem ...

Hi,

MFG/PRO on Progress RDBMS on Linux. SQL Expolorer.

Part of SELECT below rounds result to INTEGER.

SELECT ....
SUM(
cast(
case when acd_year < 2006
then cast(acd_amt as NUMERIC(25,10))
else cast(0 as NUMERIC(25,10))
end
as NUMERIC(25,10))
) BO_WN,

from pub.acd_det
.....

Where the problem is ?
Any help ...


Adam