I am replacing a character value in a SQL server table and SQL Server it is removing trailing blanks. I am using the ISQL/W tool.

Here is what I do:
UPDATE mytable
SET somefield = 'abc '
WHERE pk_mytable = 56.00

When I retrieve the value with:
SELECT ']' + somefield + '['
FROM mytable
WHERE pk_mytable = 56.00

I get ']abc[' instead of ']abc ['

I am having this problem ONLY WITH ONE TABLE. My other tables do not have this same behavior.

Any ideas? Any suggestions?