I'm having a problem trying to update rows in a table. I'm getting an error:

> 
> String or binary data would be truncated
> 
> 
> 

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.

It's just a simple update statement across every row in the table that looks like this:

```
UPDATE [tblAssets]
SET [DepartmentID] = 'B13F3C7B7489';

```

The tblAssets.DepartmentID column is a char, so I don't understand how I could possibly be getting a truncate error. 

The column definition reads:

```
[DepartmentID] [char](20) NULL

```

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.

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.

* This problem has been solved. There was a trigger at the table level that I was not aware of. Answer below.