title: Querying azure table storage for null values
body: <p>Does anyone know the proper way to query azure table storage for a null value.  From what I've read, it's possible (although there is a bug which prevents it on development storage).  However, I keep getting the following error when I do so on the live cloud storage:</p>
  
  <blockquote>
    <p>One of the request inputs is not valid.</p>
  </blockquote>
  
  <p>This is a dumbed down version of the LINQ query that I've put together.</p>
  
  <pre><code>var query = from fooBar in fooBarSVC.CreateQuery&lt;FooBar&gt;("FooBars")
          where fooBar.PartitionKey == kPartitionID
              &amp;&amp; fooBar.Code == kfooBarCode
              &amp;&amp; fooBar.Effective_Date &lt;= kFooBarDate.ToUniversalTime()
              &amp;&amp; (fooBar.Termination_Date &gt; kFooBarDate.ToUniversalTime() || fooBar.Termination_Date == null)
          select fooBar;
  </code></pre>
  
  <p>If I run the query without checking for null, it works fine.  I know a possible solution would be to run a second query on the collection that this query brings back.  I don't mind doing that if I need to, but would like to know if I can get this approach to work first.</p>
  
  <p>Anyone see anything obvious I'm doing wrong?</p>