title: SQL Null values and non-Null values
body: <p>I have a table that looks like this:</p>
  
  <pre><code>ID (pk,int)
  Col1 (nvarchar)
  Col2 (nvarchar)
  Col3 (nvarchar)
  </code></pre>
  
  <p>In all columns (except ID) some values are NULL.</p>
  
  <p>I want to make a query that will look like this:</p>
  
  <pre><code>SELECT * FROM Table 
  WHERE (Col1=&lt;parameter&gt; AND Col1 IS NULL)
   +    (Col2=&lt;parameter&gt; AND Col2 IS NULL)
  etc.
  </code></pre>
  
  <p>I need values that are NULL and that are equal to parameter</p>
  
  <p>Thanks</p>