>>>>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).
>>
>>Sergey,
>>but for this...
>>

>>SET ANSI_PADDING ON
>>SELECT CAST('aaaa  ' AS VARCHAR(20))+'X'
>>SET ANSI_PADDING OFF
>>SELECT CAST('aaaa  ' AS VARCHAR(20))+'X'
>>

>
>Fabio,
>Try storing, and getting what you've stored.
>Cetin

Cetin, i known the column ANSI_PADDING attribute,
but for columns casted at the fly this show a design bug for me.