>Hi Yossi,
>
>OK so it is the OUTER JOUN that is the problem. Make sure your NVL statement always ends up with the same length. For example if the field in question is C(10) you NVL clause would be
>NVL(something,SPACE(10)) as something
In this case, nvl() returns a numeric field value or 0, so it needs to be nvl(field,0)+0000000.00 (or zeros in whatever format it takes).