title: Select a string comparison as a boolean in tsql
body: <p>In a tsql query, I want to have a calculated field that is the boolean result of a string comparison. </p>
  
  <p>It would look something like this:</p>
  
  <pre><code>select name, (status = 'current') as IsValid
  from items
  </code></pre>
  
  <p>But the query as I have listed is not valid. What is the correct syntax?</p>