title: SQLServer - Select bool if column begins with a string
body: <p>I would like to select a boolean of whether or not a column begins with a certain string.</p>
  
  <pre><code>SELECT (name LIKE 'foo%') AS isFoo FROM bar;
  </code></pre>
  
  <p>Is there a way to do this without using an inline <code>CASE</code>?</p>