<div>
I can give you the command to update that single row but need to know what's the formula to provide a massive update command:<br />

<pre><code id="code-20-40972880-1">UPDATE tableNameHere
SET Repository_revisions='ORDERS_DOCKETSHEET_1111111_DATE_02.pdf'
WHERE Repository_revisions='ORD_DS_1111111_DATE_02.pdf'</code></pre>
</div>


I can give you the command to update that single row but need to know what's the formula to provide a massive update command:


UPDATE tableNameHere
SET Repository_revisions='ORDERS_DOCKETSHEET_1111111_DATE_02.pdf'
WHERE Repository_revisions='ORD_DS_1111111_DATE_02.pdf'

<div>
Thanks Ste5an, works great.
</div>


<div>
<div class="content wysiwyg-content">
I have a sql 2012 database with different types of field values in one field. I need to rename those values so they equal what the values should be for that field.<br />
<br />
Example:<br />
<br />
Field Name is Repository_revisions<br />
the value in that field is ORD_DS_1111111_DATE_02.pdf<wbr /><br />
<br />
I need to change this value to ORDERS_DOCKETSHEET_1111111<wbr />_DATE_02.p<wbr />df.<br />
<br />
There is over 10,000 records that I will need to change. I am fairly new to SQL 2012 and any help will be appreciated.
</div>
</div>


I have a sql 2012 database with different types of field values in one field. I need to rename those values so they equal what the values should be for that field.

Example:

Field Name is Repository_revisions
the value in that field is ORD_DS_1111111_DATE_02.pdf

I need to change this value to ORDERS_DOCKETSHEET_1111111_DATE_02.pdf.

There is over 10,000 records that I will need to change. I am fairly new to SQL 2012 and any help will be appreciated.

update a sql 2012 record by changing part of the records value

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.

Microsoft SQL Server

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.