<div>
select replace(columnname, 'string', 'withstrng')
</div>


select replace(columnname, 'string', 'withstrng')

<div>
Hello, <br />
Thank you for the suggestion.<br />
When I tried it, I got:<br />
Argument data type text is invalid for argument 1 of replace function.<br />
<br />
The field is defined as a data type of text.<br />
<br />
&nbsp;<br />
<br />

</div>


Hello,
Thank you for the suggestion.
When I tried it, I got:
Argument data type text is invalid for argument 1 of replace function.

The field is defined as a data type of text.

 



<div>
<div class="content wysiwyg-content">
In a stored procedure, How can I remove a text string in a &nbsp;text field.<br />
<br />
say:<br />
Textfield = 'Something ABCSomething else'<br />
<br />
I want to remove the 'ABC' from the text field,<br />
<br />
so that when I am done, <br />
Texfield = &nbsp;'Something Something else' <br />
<br />
Thanks in Advance,<br />
<br />

</div>
</div>


In a stored procedure, How can I remove a text string in a  text field.

say:
Textfield = 'Something ABCSomething else'

I want to remove the 'ABC' from the text field,

so that when I am done, 
Texfield =  'Something Something else' 

Thanks in Advance,



Remove a  string in a text field

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.