I was curious if you ever ran into a situation where a VFP 7 Remote view always pads the end of a string with spaces? That is say I have a VARCHAR(30) on SQL Server and pull down a row of data that contains 'Pen' - or 3 characters of
data. If this data is pushed back (saved) from VFP 7 to SQL Server 2000 it is going in as

'Pen' + SPACE(27) instead of just 'Pen' - no trailing spaces.

Of course, this defeats the purpose of a VARCHAR. Is there a way to make the VFP remote views work without adding the trailing spaces?