<div>
Also what do you want to do with the characters AFTER the @@? You say &quot;I need to first select this part &nbsp; @@576576 and remove the @@ so that I am left with &nbsp;576576.&quot; but not what to do with those and here's how you can get that data out of any of the strings you posted above -or columnname:<br />
<br />
select substring('cb8979000shdj@@<wbr />89789789',<wbr /> charindex('@@','cb8979000s<wbr />hdj@@89789<wbr />789')+2, LEN('cb8979000shdj@@897897<wbr />89')-2)
</div>


Also what do you want to do with the characters AFTER the @@? You say "I need to first select this part   @@576576 and remove the @@ so that I am left with  576576." but not what to do with those and here's how you can get that data out of any of the strings you posted above -or columnname:

select substring('cb8979000shdj@@89789789', charindex('@@','cb8979000shdj@@89789789')+2, LEN('cb8979000shdj@@89789789')-2)

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
Suppose I have a column with data like<br />
<br />
256dddggg@@576576<br />
dgg782t@@6786<br />
cb8979000shdj@@89789789<br />
cn44@@123<br />
<br />
or any other combination.<br />
<br />
I need to first select this part &nbsp; @@576576 and remove the @@ so that I am left with &nbsp;576576. Then I want to select everything before @@ and update the column with whats left hence removing everything after @@.<br />
<br />
Hope this makes sense.
</div>
</div>


Hi

Suppose I have a column with data like

256dddggg@@576576
dgg782t@@6786
cb8979000shdj@@89789789
cn44@@123

or any other combination.

I need to first select this part   @@576576 and remove the @@ so that I am left with  576576. Then I want to select everything before @@ and update the column with whats left hence removing everything after @@.

Hope this makes sense.

How can I select and then update certain characters of a string in sql server 2005?

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.

Microsoft SQL Server 2008

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.

Microsoft SQL Server 2005

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.