s

Home > mssql > mssql replace string

mssql replace string edit button Edit

author
Murugan Andezuthu Dharmaratnam | calendar 26 September 2020 | 3181

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)