I ran into the same situation and was able to accommodate by forcing a larger string than would fit. Ex: If the field was char(10) in the SQL-Server table, I would update with "test !" (11 characters), where the last character was any bogus character just to force SQL Think that they were all valid characters. But since the field was shorter than SQL just did a truncation at that last character position.

HTH


>This question is NOT about VFP but here is the only place where I can ask it.
>
>I am replacing a character value in a SQL server table and SQL Server it is removing trailing blanks. I am SURE that VFP is NOT the problem because when I replace the value using the ISQL/W tool that comes with SQL Server I have the same problem.
>
>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?