One additional test:

CREATE TABLE MONEY_TABLE (
MONEY1 NUMERIC(18,5),
MONEY2 NUMERIC(18,4),
MONEY3 NUMERIC(18,3),
MONEY4 NUMERIC(18,2));

INSERT INTO MONEY_TABLE (MONEY1,MONEY2,MONEY3,MONEY4) VALUES (-70000,-700000,-7000000,-70000000);

select
money1,money1/1.95583,
money2,money2/1.95583,
money3,money3/1.95583,
money4,money4/1.95583
from MONEY_TABLE

All results are wrong :-(


Guido