title: Query SQL Server with IN (NULL) not working
body: <p>When I define a "User-Defined Table Type", as:</p>
  
  <pre><code>CREATE TYPE [dbo].[BitType] AS TABLE(
      [B] [bit] NULL
  )
  </code></pre>
  
  <p>I place 0 and null in this table-variable.
  Then I do this query:</p>
  
  <pre><code>SELECT something FROM theTable WHERE item IN @theBitTypeTable
  </code></pre>
  
  <p>Will only get <code>item=0</code> not <code>item is null</code></p>
  
  <p>Simply put: <code>SELECT something FROM theTable WHERE item IN (0, NULL)</code> is not working (no error although)
  It has to be <code>SELECT something FROM theTable WHERE item=0 OR item IS NULL</code></p>
  
  <p>So, my question is, if I like to use <strong>User-Defined Table Type</strong>, but I also need to use NULL value. How can I perform the query correctly to get result include null item.</p>
  
  <p>Thanks (btw, I use MS SQL Server 2008 R2)</p>