> Thanx for your help!! The problem finally solved by using NUMERIC(18,5)
> casting instead of (18,2). It works perfectly. The precision digits were
> not enough for the right calculation.
>
> Now the summed values always equal the input value.

Does that mean I get my 3 Euros back?


With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com