Any Chance Of Using The AVG() Function To Ignore The Zero Value??

Hi! I'm wondering if there is a way to have the AVG() not to include the zero amount as part of the calculation. I'm looking
the field, PurchPrice and RepairCost that are used by the AVG() function...


Code:


SELECT Year, MakeID, ModelID, Style, AVG(PurchPrice), AVG(RepairCost)FROM vwAvgPurchase

WHERE StockDate >= (GETDATE()- 365)
GROUP BY Year,MakeID,ModelID, Style



I don't want to do this way...


Code:


SELECT Year, MakeID, ModelID, Style, AVG(PurchPrice), AVG(RepairCost)FROM vwAvgPurchase

WHERE StockDate >= (GETDATE()- 365)
and (PurchPrice > 0 or RepairCost > 0)

GROUP BY Year,MakeID,ModelID, Style



because the PurchPrice would sometime be zero and the RepairCost wouldn't be zero.