how to filter records that including null values and other status
<p>Currently I am running below query in sql server. How to filter whose <code>checkpointstatus</code> is not 'Completed' including <code>null</code> values. But the issue is I am not able to get those records whose values are null.</p>

<pre><code>  SELECT * FROM TAMS.OrderDetail WHERE CheckPointStatus != 'Completed'
</code></pre>

<p>I have tried to fix this by :</p>

<pre><code>  SELECT * FROM TAMS.OrderDetail WHERE coalesce(CheckPointStatus, '') !=  'Completed'
</code></pre>

<p>But just want to make sure is this correct way?</p>