<div>
&gt;The 'COLUMN1' is of type text.<br />
<br />
do you need to have TEXT as data type?<br />
is varchar(8000) &nbsp; in sql server 2000 resp varchar(max) in sql server 2005 not enough?
</div>


>The 'COLUMN1' is of type text.

do you need to have TEXT as data type?
is varchar(8000)   in sql server 2000 resp varchar(max) in sql server 2005 not enough?

<div>
I cannot change the design of the table. I dont have rights. Is it not possible to add two text fields?<br />
<br />
thanks,
</div>


I cannot change the design of the table. I dont have rights. Is it not possible to add two text fields?

thanks,

<div>
&gt;Is it not possible to add two text fields?<br />
as shown it is possible, but you will only get up to 8000 characters in that field. if you try to store more, it will get truncated...
</div>


>Is it not possible to add two text fields?
as shown it is possible, but you will only get up to 8000 characters in that field. if you try to store more, it will get truncated...

<div>
<div class="content wysiwyg-content">
I would like to update a column in a table with a string. Later on I would like to add to that string. <br />
<br />
I tried the following query,<br />
<br />
&quot;update TABLE1 set COLUMN1 = COLUMN1 + 'TEST STRING' &nbsp;where ID = 100&quot;<br />
<br />
I get this error, &quot;Invalid operator for data type. Operator equals add, type equals text.&quot;<br />
<br />
The 'COLUMN1' is of type text.<br />
<br />
Any help is appreciated.<br />
<br />
thanks,
</div>
</div>


I would like to update a column in a table with a string. Later on I would like to add to that string. 

I tried the following query,

"update TABLE1 set COLUMN1 = COLUMN1 + 'TEST STRING'  where ID = 100"

I get this error, "Invalid operator for data type. Operator equals add, type equals text."

The 'COLUMN1' is of type text.

Any help is appreciated.

thanks,

Appending two strings in SQL

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.