>I created a view which is based on ODBC setting for an SQL server table. IF VFP when I set a 10 character field a value
>of "ABC" in a new record, after I update the SQL table, the field is saved to the SQL server
>table as "ABC" padded to the right with 7 spaces. Is there any way either through a VFP command or ODBC setting
>or possibly an SQL server setting to prevent this from happening ?
>
>Thanks for your help
>Stephen J. Hunt

I am new to SQL Server, but can you define the field as varchar(10)?