The following example uses COALESCE with an arithmetic operator. SELECT COALESCE(Boxes,0) * 100 FROM Shipments;