title: How to convert a varchar column to bit column in SQL SERVER
body: <p><code>Flag1</code> is a <code>varchar</code> column with values "true" and "false". I need to convert this into bit column.</p>
  
  <p>When I try to do this:</p>
  
  <pre><code>Convert(Bit,Flag1)
  </code></pre>
  
  <p>it shows an error</p>
  
  <pre><code>Msg 245, Level 16, State 1, Line 2
  Syntax error converting the varchar value 'False' to a column of data type bit.
  </code></pre>