<div>
you can check value by selecting it before executing update statement.<br />
<br />
select replace(yourfiledname,'|\\<wbr />server\fol<wbr />der1\folde<wbr />r2\folder3<wbr />\document'<wbr />,'|\\diffe<wbr />rentserver<wbr />\folder1\f<wbr />older2')<br />
from tablename where server1='condition'<br />

</div>


you can check value by selecting it before executing update statement.

select replace(yourfiledname,'|\\server\folder1\folder2\folder3\document','|\\differentserver\folder1\folder2')
from tablename where server1='condition'


<div>
Yep, I actually figured that out about 2 minutes ago. Thanks for the help, though.
</div>


Yep, I actually figured that out about 2 minutes ago. Thanks for the help, though.

<div>
<div class="content wysiwyg-content">
Hello everyone.<br />
<br />
I have a table with four columns. One of these columns contains data about specific locations of items, which I need to change. I'd like to update the table, replacing all instances of the server share location with a different one. <br />
<br />
I need to select &quot;|\\server\folder1\folder2<wbr />\folder3\d<wbr />ocument&quot; and replace it with &quot;|\\differentserver\folder<wbr />1\folder2&quot;<wbr /> etc.<br />

</div>
</div>


Hello everyone.

I have a table with four columns. One of these columns contains data about specific locations of items, which I need to change. I'd like to update the table, replacing all instances of the server share location with a different one. 

I need to select "|\\server\folder1\folder2\folder3\document" and replace it with "|\\differentserver\folder1\folder2" etc.


Update Column Data in Table

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.