Subject Re: [ib-support] Stored proc refuses to divide two numbers!
Author Peter Faulks
On Tue, 28 May 2002 17:00:47 -0000 "csswa" <csswa@...> wrote:


> --1-- RET_RESULT = 100 / 300;
> --2-- RET_RESULT = CAST((100 / 300) AS DOUBLE PRECISION);
> --3-- RET_RESULT = 0.123;
> --4-- RET_RESULT = 1 + 1;

CAST(100 AS DOUBLE PRECISION) / CAST(300 AS DOUBLE PRECISION)

Regards