mssql replace string Edit

Murugan Andezuthu Dharmaratnam | 26 September 2020 | 642

You can replace a string in SQL Server using REPLACE() Function

Example

select REPLACE('hello replace this is a test','replace','world')
              
                    

Output

hello world this is a test

syntax of replace function is REPLACE(string, old_string, new_string)