>I haven't seen VFP9 yet but as far as I know from SQL server a varchar field doesn't have trailing spaces.

Cetin,

That depends on the SET ANSI_PADDING setting. When it's OFF trailing spaces aren't stored, otherwise data inserted into a column "AS IS" (w/o trimming trailing spaces if there are any).