>I am using VFP 7 and SQL Server 2000. Foxpro does not have a varchar datatype and I am using varchars in SQL Server. I want to be able to trim the trailing spaces. Is there anyway to have foxpro pass a field to SQL Server and have it convert to a varchar. Does VFP 8 have a varchar datatype?

Tracey,
With SQL Server, you can change the ANSI_PADDING setting for the ODBC connection. This will configure how VFP sends trailing spaces for Varchar fields.

HTH.