Greetings,
I'm using FB 1.03 and have the following SP:

create procedure sp_test_pct
returns (Pct Numeric(8,6))
as
begin
Pct = Cast((29920 / 106532) as Numeric(8,6) );
suspend;
end

Right now, Pct is returned as all zeros and it should be something like:
0.280854

I've tried w/out the casting as well with the same zero results.

Any ideas would be GREATLY appreciated.

Kevin