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!