SQL Tutorial: How to Replace String in SQL Server

How To Replace String in SQL Server?

May be you have faced/facing the situation when you need to replace string in sql server. But there is a lot of ways available out there to replace string in sql server. Here is the simplest way replace string in sql server.

UPDATE TableName SET ColumnName = replace(ColumnName, 'OldString', 'NewString')

Hope This will help you.

 

 

Nahidur Rahman Rifath

Passionate Software Engineer, Content Writer, Reader

2 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *