I have no idea if this would work, but it wouldn't surprise me to hear that it did. Try making the field in your remote view a memo field and then place the value with the trailing space at the end into that field.

I had the same problem in reverse... Spaces were being added every time I wrote, so I went to memo fields, then only the exact string I wanted was written to the data base server.


>The field data type is CHAR(6) and it accepts NULL values. There is no index associated to this field.
>
>
>>What is the SQL Server data type? Varchar, text, char, what?
>>
>>>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?