> 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?
>
> TIA
> 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
Alan