1 million thanks
=========
|| ISMAEL ||
=========

----- Original Message -----
From: Huan Ruan
To: firebird-support@yahoogroups.com
Sent: Tuesday, March 01, 2011 7:21 PM
Subject: Re: [firebird-support] Err Number 335544779



> SELECT cast(((163303.39/49.215486) * 89.218715) as decimal(15,2)) as val
> from MON$DATABASE
>

try

SELECT cast(((*cast(*(163303.39/49.215486) *as double precision)*) *
89.218715) as numeric(15,2)) as val from MON$DATABASE

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]