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?
Hector Correa