It has been announced that VFP 9 (Europa) will have a varchar datatype (among other ones to match SQL types).

>However I don't believe that even with this setting, Remote Views will update properly.
>
>Rick
>
>>>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.