Am Donnerstag, 12. Februar 2009 11:40 schrieb Daniel Albuschat:

> Hello there,
> I'm struggling with rounding fields that are stored in numeric(15,2) to the
> last two digits. Is there any way I can do this in 1.5? Hadn't had that
> much luck with the round() function, it always returns NULL for me on those
> fields.:/

I did it with
cast (fieldvalue * 100.0 as integer) / 100.0
fr.

>
> Unfortunately, I'm currently bound to Firebird 1.5 and can't upgrade to
> 2.0.
>
> Thanks in advance,
>
> Daniel Albuschat
>
>
> [Non-text portions of this message have been removed]