title: String or binary data would be truncated - Msg 8152
body: <p>I'm having a problem trying to update rows in a table. I'm getting an error:</p>
  
  <blockquote>
    <p>String or binary data would be truncated</p>
  </blockquote>
  
  <p>However, I've double checked the length of the data being inserted and the column lengths and they are all within parameters, so I'm at a loss as to what may be causing it.</p>
  
  <p>It's just a simple update statement across every row in the table that looks like this:</p>
  
  <pre><code>UPDATE [tblAssets]
  SET [DepartmentID] = 'B13F3C7B7489';
  </code></pre>
  
  <p>The tblAssets.DepartmentID column is a char, so I don't understand how I could possibly be getting a truncate error. </p>
  
  <p>The column definition reads:</p>
  
  <pre><code>[DepartmentID] [char](20) NULL
  </code></pre>
  
  <p>My account has administrative privileges across the server, so it's not a rights issue.  I've even tried creating a variable and loading it with the appropriate data from another table through a select statement, but that doesn't work either.</p>
  
  <p>I am able to manually cut-paste that data into individual records, but it will not let me perform an update through a SQL query into the table.  The server is MS SQL 2008 R2.</p>
  
  <ul>
  <li>This problem has been solved.  There was a trigger at the table level that I was not aware of.  Answer below.</li>
  </ul>