Subject RE: [firebird-support] Percentage Calculation?
Author Alan McDonald
> Hi,
> Is there a way in FB SQL to calculate a percentage column line
> Custid, Sum(Sales-Cost)/Sum(Sales) AS GM%
> so that gm% would be returned as %##0.000 or will this have to be
> handled by the calling program?
> Dan

you could cast as numeric(5,2), then varchar, then add a '%' if you want but
doing it at the client side is the more usual thing to do