I have this stmt as part of the SELECT:

SUM(aritem.fshipqty*aritem.fcost)/Sum(aritem.ftotprice) AS 'MatlCost %'

Sometimes sum(ftotprice)=0, which returns an error that SQL can't divide by 0. The ftotprice field is never Null.

How do I get around this?

Thanks.