|Subject||RE: [firebird-support] Percentage Calculation?|
> Hi,you could cast as numeric(5,2), then varchar, then add a '%' if you want but
> 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?
doing it at the client side is the more usual thing to do