On Thursday 2002-02-14 at 02:28:55 +0100, guido.klapperich@... wrote:

> I have the following query
> select to1valuens as DM,(to1valuens/1.95583) as EURO
> from TURNOVER_CS_MP_MONTH
> where to1csid=6 and to1paid=1 and to1mpid=2
>
> and the result
> DM EURO
>
> 149.115,080000 76.241,329768
> -77.374,130000 -1.834,082566
> 80.532,730000 41.175,731020
> 205.586,430000 105.114,672543
> 284.087,030000 145.251,391992
> 711.952,750000 364.015,660870
> 212.314,730000 108.554,797707
> 576.549,930000 294.785,298313
> 404.336,820000 206.734,133335
> 327.176,500000 167.282,688168
> 288.400,760000 147.456,967119
> -190.479,560000 -3.073,947768

What happens if you use:

SELECT
to1valuens DM,
(to1valuens / CAST(1.95583 AS NUMERIC(18,6))) EURO
FROM
Turnover_CS_MP_Month
WHERE
to1csid = 6 and to1paid = 1 and to1mpid = 2


and:


SELECT
to1valuens DM,
CAST((to1valuens / CAST(1.95583 AS NUMERIC(18,6))) AS
NUMERIC(18,5)) EURO
FROM
Turnover_CS_MP_Month
WHERE
to1csid = 6 and to1paid = 1 and to1mpid = 2



David Trudgett