Nicholas,

I'm not sure I understand. . . FP/VFP fills its 6-character fields with 6 characters, using blanks at the end if necessay. You want VFP and SQL6 to be different???

Jim N

>Hi,
>
>When i try to upsize(WIZARD) a table from VFP5 into SQL6.5 it upsize, but if a field in VFP5 is C(6) and is filled with 'HELLO' it will add spaces in SQL6.5 to fill in the remaining blanks and the make it 'HELLO '.
>
>I need to remove those spaces. I tried setting everything to .NULL.
>fields in VFP5 but didn't help.
>
>Any help will be greatly appreciated.
>
>Bye,