Urgent Problem With Strings

Hi,

I wrote a strore procedure (MS SQL DBMS) that concatenates few strings
and then write the resuls into a field of my table. I use a variable
@temp ( varchar(800) ) to add all the string I need.

For example:

@temp = @temp + string1

@temp = @temp + string2...



Nevertheless, even if I have declared @temp as varchar(800),  and
the length of the strings that I added is for istance 334 , @temp loses
part fo the last string.



Why?





This is my store procedure:



CREATE         PROCEDURE dbo.AddSearchColumn AS

Declare @cElements cursor,

@DocNum integer,

@Fname varchar(30),

@Lname varchar(30),

@Loc varchar(50),

@titleV varchar(200),

@KeyV varchar(250),

@temp varchar(800),

@a integer



begin transaction

Set @cElements = cursor for select DocNumber,Title,

FirstName,LastName,Location,Keywords from dbo.DocTable1



open @cElements

    fetch NEXT from @cElements into @DocNum,@titleV,@Fname,

@Lname,@Loc,@KeyV

while (@@FETCH_STATUS = 0)

begin   

set @temp=convert(varchar(4),@DocNum)+';'+rtrim(ltrim(@titleV))+';'+

rtrim(ltrim(@Fname))+';'+rtrim(ltrim(@Lname))+';'



if @Loc is not null

    set @temp= @temp + rtrim(ltrim(@Loc))+';'



if @KeyV is not null

    set @temp= @temp + rtrim(ltrim(@KeyV))+';'

if @DocNum=436

set @a=2



UPDATE dbo.DocTable1

set SearchColumn=@temp where DocNumber=@DocNum

commit



fetch NEXT from @cElements into @DocNum,@titleV,@Fname,

@Lname,@Loc,@KeyV

END



close @cElements

DEALLOCATE @cElements

















GO