How to increase value of a "TEXT" variable in a table

[Plato2]

I have a table with a field that is declared as a TEXT variable. But I cannot update the value of that variable - I need to append additional varchar value to this text field but I cannot do that. Is there is a way to solve the problem?

Thanks in advance

 

[JayKusch]

Lets see the code.

Thanks

J. Kusch

 

[Plato2]

For example I try to use an update statement to change the value of a column that is declared as TEXT

CREATE TABLE SomeTable
(
TextColumn Text
)
update SomeTable
set TextColumn=TextColumn+' Append Some String'

doesn't work saying that I cannot use TEXT columns to appent - inavlid + operation......

Any solution to append this column?

Thanks

 

[jbenson001]

See the Books On Line.. it is not that straigh forward

 

[mrdenny]

You can't append to a text field using the update statement like you can with a varchar field. You need to use the UPDATETEXT command.

declare @NewText as varchar(100)
declare @ptrval varbinary(16)
set NewText = 'New text data.'
select @ptrval = TEXTPTR({TextField})
from {Table}
where {Key} = @{Variable}
UPDATETEXT {Table}.{TextField} @ptrval null 0 @NewText

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)