Append paramater to end of text datatype in stored prodecure.

[JustBarno]

in the following stored procedure, how would I append the @notes param to the end of the column named notes with the datatype of text.

CREATE PROCEDURE PMC_Bro_UpdateBlast
@Fax int,
@Email int,
@CustId varchar(10),
@notes varchar(100)
AS
Update tbl_cust SET fax = @fax, email = @email WHERE idnum = @CustId
GO

 

[hmckillop]

CREATE PROCEDURE PMC_Bro_UpdateBlast
@Fax int,
@Email int,
@CustId varchar(10),
@notes varchar(100)
 AS
Update tbl_cust 
SET fax = @fax, 
email = @email 
notes = notes + @notes
WHERE idnum = @CustId 
GO

"Own only what you can carry with you; know language, know countries, know people. Let your memory be your travel bag.

 

[JustBarno]

Error 403: Invalid operator for data type. Operator equals add, type equals text.

I had already tried that

 

[hmckillop]

Try the & instead of +

"Own only what you can carry with you; know language, know countries, know people. Let your memory be your travel bag.

 

[JustBarno]

Error 403: Invalid operator for data type. Operator equals boolean AND, type equals text.

 

[JustBarno]

fixed it by casting the "text" datatype to a varchar.

Hope this helps someone