title: Column not updating when tried to update a value of type varchar
body: <p>I am using SQL Server 2000. When I try to update a column of type <code>varchar(20)</code> with a text value of more than 10 characters, I get an error </p>
  
  <blockquote>
    <p>String or binary data would be truncated.</p>
  </blockquote>
  
  <p>Why is it? <code>varchar(20)</code> should accept a text of up to 20 characters... why can I not update it with text with more than 10 characters?</p>