How to match not null + not empty? : <p>I have to do some queries on a messy database. Some columns are filled with either <code>null</code> or empty string. I can do query like this:</p>

<pre><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 "not empty" values) Something like: </p>

<pre><code>select * from a where b is filled;
</code></pre>
