Replace coalesce with case
<p>How can I refactor this query so there is no COALESCE or ISNULL? Can I change it so it uses CASE? Is there any other way to refactor it? </p>

<pre><code>SELECT * FROM MockDb WHERE 
COALESCE(Column1,0) = @value1 AND 
COALESCE(Column2,0) = @value2 AND 
COALESCE(Column3,0) = @value3 AND 
COALESCE(Column4,0) = @value4 AND 
COALESCE(Column5,0) = @value5
</code></pre>