title: SQL Server: Cast bool as integer
body: <p>Why does the query:</p>
  
  <pre><code>SELECT CAST((column LIKE '%string%') AS INT)+100
  </code></pre>
  
  <p>return</p>
  
  <blockquote>
    <p><em>Incorrect syntax near the keyword 'AS'</em></p>
  </blockquote>