title: Error Message: String was not recognized as a valid Boolean in sql sever 2008
body: <p>Bit columns store a 1 or a 0.</p>
  
  <p>Entering 1 or 0 in a bit column gives the ERROR:</p>
  
  <blockquote>
    <p>Invalid value for cell (row 42, column 17).</p>
    
    <p>The changed value in this cell was not recognized as valid. .Net
    Framework Data Type: Boolean Error Message: String was not recognized
    as a valid Boolean.</p>
    
    <p>Type a value appropriate for the data type or press ESC to cancel the
    change.</p>
  </blockquote>
  
  <p>How can 1 or 0 NOT be a valid boolean?</p>
  
  <p>Bit fields should allow 1 or 0.</p>