title: How to match not null + not empty?
body: <p>I have to do some queries on a messy database. Some columns are filled with either <code>null</code> or an empty string. I can do a query like this:</p>
  <pre class="lang-sql prettyprint-override"><code>select * from a where b is not null and b &lt;&gt; '';
  </code></pre>
  <p>But is there a shortcut for this case? (match every &quot;not empty&quot; value) Something like:</p>
  <pre class="lang-sql prettyprint-override"><code>select * from a where b is filled;
  </code></pre>