I'm on AIX 5.2 DB2 8.1.4

Does anyone know how I can get this query
to return decimal values in the first column?

The underlying data type is smallint.

select avg(v_alder), year(d_dodsdto) as aar, mast.cprkoen(k_cpr) as kon
from dar.t_dodsaars
where year(d_dodsdto)>1995
group by year(d_dodsdto), mast.cprkoen(k_cpr)
order by 2, 3;

Thank You

Try using the cast function to change the data type to decimal.

Hi Marcus

Thanks - I did, and it works.

HTH