Posted by Ed Murphy on 10/14/06 03:25

adamwalan@yahoo.com wrote:

> Why this always returning 'AAA'
>
> declare @ss char(20)
>
> set @ss='AAA'
>
> set @ss=@ss+'BBB'
> print @ss

Try either
declare @ss varchar(20)
or
set @ss=rtrim(@ss)+'BBB'

• Next in forum: Re: weird database back up sizes
• Prev in forum: viable question
• Thread view: Re: viable question

[Reply to this message]