title: SQL View does not accept Subclause
body: <p>I need to get a boolean field in a view from a string field in the table. The boolean field should be <code>True</code> if the string is filled:</p>
  
  <pre><code>SELECT (MasterId IS NOT NULL) AS HasMaster FROM entries
  </code></pre>
  
  <p>However, this causes the error:</p>
  
  <blockquote>
    <p>incorrect syntax near the keyword 'IS'</p>
  </blockquote>
  
  <p>Why is that and how to fix?</p>