>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

Hi Stephen,

If field on Sql Server is char(10) than it will be alwys padded to the 10 charcters. If field is varchar(10) than padding will depends on setting of SET ANSI_PADDING at the time when table was created. See SET ANSI_PADDING (T-SQL) in BOL for details.