title: Is there a way to get a boolean without casting in SQL Server?
body: <p>I've found it very weird that simple code like this is not valid:</p>
  
  <pre><code>select * from table where field=true
  </code></pre>
  
  <p>The alternative apparently being</p>
  
  <pre><code>select * from table where field='true'
  </code></pre>
  
  <p>Ok, guess I can live with that. For one reason or another I needed to do something like this recently:</p>
  
  <pre><code>select true as somefield,...
  </code></pre>
  
  <p>The alternative to get types and everything right was much more ugly though:</p>
  
  <pre><code>select cast('true' as bit) as somefield,...
  </code></pre>
  
  <p>Am I missing something? Is there actually some built in way to get a true or false value as a boolean without casting?</p>