s

mssql replace string edit button Edit

author
Murugan Andezuthu Dharmaratnam | calendar 26 September 2020 | 2676

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)