JR,

Thanks for the tip, but i've already tried ALLTRIM() with no success.
The problems still remains.

Sincerly yours,

Nick

>I don't know much about SQL Server, so this may be sophomoric, but did you try the RTRIM() function?
>
>JR
>
>>Hi,
>>
>>When I try to INSERT a record in a SQL Data Source Table with VFP 5
>>and the field length is 8 caracters long, but i only fill in 5 caracters it replaces the other 3 caracters with spaces.
>>
>>If i upsize with the VFP wizard. The wizard won't add any spaces to fill in the blanks.
>>
>>Can i avoid these space?
>>
>>Nick
>>Thank You!