Adding text to a text column

[Metalzed]

Hi

I want to have a log so in my table i got a TEXT field called LOGG. I want to update this field with new data by adding more text to field.

I am using MS SQL

'test' + 'test' doesn't work . say you cant add 2 text to each other

concat('test','test') doesn't work . say that CONCAT isn't a built in function


this code works but is it really the best way to do? and how long can a varchar be?

UPDATE    GAMES
SET LOGG =
CAST(CAST(LOGG AS varchar(200)) + CAST('test' AS varchar(5)) AS text)
 
WHERE     (ID = 21)

[galexyus]

Hey,

Use this instead:

DECLARE @ptrval varbinary(16)
 
 
SELECT @ptrval = TEXTPTR(LOGG)
FROM GAMES
WHERE ID = 21
 
UPDATETEXT GAMES.LOGG @ptrval NULL NULL 'your text'
 

And varchar can be 8000 long.

[Metalzed]

Thanks for the help. worked perfekt.

Hey,

Use this instead:

DECLARE @ptrval varbinary(16)
 
 
SELECT @ptrval = TEXTPTR(LOGG)
FROM GAMES
WHERE ID = 21
 
UPDATETEXT GAMES.LOGG @ptrval NULL NULL 'your text'
 

And varchar can be 8000 long.

[bayatloo]

you can use this samlpe

UPDATE Yourtable SET Bemerkung = convert(varchar(2000),Bemerkung) + 'Yourtext hire ' WHERE ID= 111111