<div>
you can do it this way unless you have additional info for your request:<br />
select replace ('gfjhtyjtyThe Dancing Paintbrush watermark will not be on the order you receive.mhgkhjk','The Dancing Paintbrush watermark will not be on the order you receive.','<i>The Dancing Paintbrush watermark will not be on the order you receive.</i>') <br />

</div>


<div>
hmm try again<br />

<pre><code class="code-1 nolinks" id="code-125132"><span>select replace ('gfjhtyjtyThe Dancing Paintbrush watermark will not be on the order you receive.mhgkhjk','The Dancing Paintbrush watermark will not be on the order you receive.','&lt;br/&gt;&lt;br/&gt;&lt;em&gt;The Dancing Paintbrush watermark will not be on the order you receive.&lt;/em&gt;')</span>
</code></pre>
</div>


<div>
Can you not just use a SQL update &amp;&nbsp;T-SQL Replace statements?<br />
<br />
Ex. &nbsp;Something like this:<br />
&nbsp; &nbsp; &nbsp; &nbsp;Update product_description<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Set product_description = REPLACE(product_descriptio<wbr />n, <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'The Dancing Paintbrush watermark will not be on the order you receive.',<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; '<i>The Dancing Paintbrush watermark will not be on the order you receive.</i>'<br />

</div>


<div>
Sorry, typos in my SQL. &nbsp;Should be:<br />
<br />
<br />
<br />
<br />

<pre><code class="code-1 nolinks" id="code-125139"><span>Update Table_Name</span>
<span>Set product_description = REPLACE(product_description,</span>
<span>             'The Dancing Paintbrush watermark will not be on the order you receive.',</span>
<span>             '&lt;br/&gt;&lt;br/&gt;&lt;em&gt;The Dancing Paintbrush watermark will not be on the order you receive.&lt;/em&gt;')</span>
</code></pre>
</div>


<div>
thanks!<br />
<br />
what does this mean &quot;gfjhtyjty&quot;<br />
<br />
is that the complete query?<br />
<br />
Thanks<br />
<br />
<br />

</div>


<div>
I think that was to demonstrate that the statement will work even if the &quot;Dancing Paintbrush&quot; string was preceded or proceeded by additional text.
</div>


<div>
ryjdawg,<br />
<br />
I tried your query and i get a error of Argument data type ntext is invalid for argument 1 of replace function<br />
<br />
below is the SQL i used, i copied and pasted out of enterprise manager<br />

<pre><code class="code-1 nolinks" id="code-125161"><span>UPDATE    dbo.tbl_products</span>
<span>SET              product_Description = REPLACE(product_Description, 'The Dancing Paintbrush watermark will not be on the order you receive.', </span>
<span>                      '&lt;br/&gt;&lt;br/&gt;&lt;em&gt;The Dancing Paintbrush watermark will not be on the order you receive.&lt;/em&gt;')</span>
</code></pre>
</div>


<div>
Sorry, I forgot to cast to nvarchar<br />

<pre><code class="code-1 nolinks" id="code-125166"><span>cast(product_Description as nvarchar(max))</span>
<span> </span>
<span>UPDATE    dbo.tbl_products</span>
<span>SET       product_Description = REPLACE(cast(product_Description as nvarchar(max)), </span>
<span>                      'The Dancing Paintbrush watermark will not be on the order you receive.', </span>
<span>                      '&lt;br/&gt;&lt;br/&gt;&lt;em&gt;The Dancing Paintbrush watermark will not be on the order you receive.&lt;/em&gt;')</span>
</code></pre>
</div>


<div>
what does cast mean, does that change the column data type?
</div>


<div>
Cast does not change the column type. &nbsp;That would require using an &quot;Alter&quot; statement.<br />
<br />
Cast merely retrieves the column data and converts it to the specified type (if possible) for use in the remainder of the statement. &nbsp;In this case, when the data gets written back to the ntext column, it is stored as ntext. &nbsp;Cast is equivalent to the Convert class in .Net or the CStr, CBool, CDate, etc. functions in VB.Net.<br />
<br />
Incidentally, there is also a CONVERT function in Transact-SQL. &nbsp;See &quot;SQL Server Books Online&quot;. &nbsp;It's a really good reference for things like this.<br />
<br />
Short answer: no it doesn't. &nbsp;:)<br />

</div>


<div>
also, depending on which version of SQL Server you're using, you may have to cast to varchar(8000). &nbsp;I don't think nvarchar or max are a part of SQL Server 2000
</div>


<div>
i received an error of Incorrect syntax near 'MAX'<br />
<br />
I am checking on the version of MS SQL that the hosting environment is running<br />

<pre><code class="code-1 nolinks" id="code-125234"><span>UPDATE    dbo.tbl_products</span>
<span>SET       product_Description = REPLACE(cast(product_Description as nvarchar(max)),'The Dancing Paintbrush watermark will not be on the order you receive.','&lt;br/&gt;&lt;br/&gt;&lt;em&gt;The Dancing Paintbrush watermark will not be on the order you receive.&lt;/em&gt;')</span>
</code></pre>
</div>


<div>
<div class="content wysiwyg-content">
I need to go thru a DB table find some text and replace it with new. How do i do this?<br />
<br />
the column name is product_description<br />
column data type is ntext<br />
<br />
in the column i am looking for this length of text<br />
<br />
The Dancing Paintbrush watermark will not be on the order you receive.<br />
<br />
and i want to replace it with this<br />
<br />
&lt;br/&gt;&lt;br/&gt;&lt;em&gt;The Dancing Paintbrush watermark will not be on the order you receive.&lt;/em&gt;<br />
<br />
<br />
so i am adding the returns and the italic tags<br />
<br />
so of the columns have just that string of text and some others have that string but other text.<br />
<br />
everything i have found online seems so complicated. Isnt there and easy way to do this?<br />
<br />
Thanks!<br />
<br />

</div>
</div>


I need to go thru a DB table find some text and replace it with new. How do i do this?

the column name is product_description
column data type is ntext

in the column i am looking for this length of text

The Dancing Paintbrush watermark will not be on the order you receive.

and i want to replace it with this

<br/><br/><em>The Dancing Paintbrush watermark will not be on the order you receive.</em>


so i am adding the returns and the italic tags

so of the columns have just that string of text and some others have that string but other text.

everything i have found online seems so complicated. Isnt there and easy way to do this?

Thanks!



find and replace SQL query

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.