>>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.