This is the Code I Have, But it throws an exception
UPDATE rdm_comments SET commentinfo = commentinfo + 'additional info' where commentid=2356
I get an Error stating that i cannot use the addition operator for a string. Help
DECLARE @ptr varbinary(16)
DECLARE @len int
select @ptr = TEXTPTR(commentinfo), @len=datalength(commentinfo)/2 from rdm_comments where commentid=2356
UPDATETEXT rdm_comments.commentinfo @ptr @len 0 'additional info'
Note, in my example length of commentinfo is divided by 2 because I assumed commentinfo has ntext data type. If it has text data type then remove dividing.
In SQL Server 2005, you can use one of the new large value data types for this column: for example NVARCHAR(MAX).
You can run this query by using (.WRITE ( expression, @Offset , @Length )) for this column:
Update
rdm_comments set commentinfo.write('additional info',len(commentinfo),1)WHERE
commentid=2356--OR
Update rdm_comments
set commentinfo.write('additional info',null,null )--append to the end
WHERE
commentid=2356Does MSSQL2005 support len() function for ntext/text columns?
No. but this one: DATALENGTH(columnname).
The one I was using is for NVARCHAR(MAX) if choose to use the .WRITE function for update.
Try This:
UPDATE Table SET Text = (Convert(varchar(8000), Text)+' my extra text')