Empty fields when I execute the select query <p>I have table <code>tableq</code> with columns lets say; a, b, c, d, e, f. in column <code>f</code> null values are allowed of which there are some null field in column <code>f</code>.</p> <p>Now I want to select a,b,c,d,e columns where <code>f</code> is null. Like this: </p> <pre><code>select a, b, c, d, e from tableq where f isnull </code></pre> <p>But it is returning empty fields when I run the query whereas there are 3 rows with null values in f column.</p>