title: How to query Azure Table storage by nullable fields?
body: <p>I have table with nullable fields :</p>
  
  <pre><code>public int? Order {get; set;}
  public DateTime? StartDate {get; set;}
  public DateTime? EndDate {get; set;}
  public string Text {get; set;}
  </code></pre>
  
  <p>All this fields can be with NULL value</p>
  
  <p>Problem starts when I want to query records </p>
  
  <ul>
  <li><p>where Order, StartDate, EndDate and Text aren't NULL or </p></li>
  <li><p>where Order, StartDate and Text aren't null but EndDate is null or</p></li>
  <li><p>where Order and Text aren't null but StartDate and EndDate are null</p>
  
  <p><code>Order.HasValue &amp;&amp; StartDate.HasValue &amp;&amp; EndDate.HasValue &amp;&amp; !string.IsNullOrEmpty(Text) || Order.HasValue &amp;&amp; StartDate.HasValue &amp;&amp; !EndDate.HasValue &amp;&amp; !string.IsNullOrEmpty(Text) || Order.HasValue &amp;&amp; !StartDate.HasValue &amp;&amp; !EndDate.HasValue &amp;&amp; !string.IsNullOrEmpty(Text)</code></p></li>
  </ul>
  
  <p>Using such query I get error or 400 (bad request) or unsupported operator (isnullorempty isn't supported)</p>
  
  <p>According to this answer <a href="https://stackoverflow.com/a/4263091/3917754">https://stackoverflow.com/a/4263091/3917754</a> it is impossible to query NULL values...</p>