isnull

This query finds the average of the prices of all titles, substituting the value “$10.00’’ for all NULL entries in price:

select avg(isnull(price,$10.00)) 
from titles

------------
       14.24
 
(1 row affected)