>>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,
>
>What's your question or comment?

Only this:
if you, in a sp_xxx, return data with a SELECT and SET ANSI_PADDING OFF
SQL don't remove trailing spaces;
if, after, you chnge the sp_xxx,
and put data into a temp table and return temp table,
the result is different.