Is there a way to for a query to return a default value (specified in the query) if a request value is NULL?

In my case I am returning an average wage for each employee record but people without wages should return some sort of default amount rather than just blank/null.

Thanks

SELECT employee, AVG(COALESCE(wagefield, 0))
FROM emptable
WHERE ...

"0" in this example is the default value.

Awesome, thanks for the help. It worked perfect.