SQL Replace

The SQL Replace function is used to replace every occurrences of a specified string with a replacement string.

SQL Replace Function Syntax

REPLACE(string_original, string_search, string_replacement)

The SQL Replace function will replace every string_search in string_original with string_replacement.

Note: If any of the string expression is NULL, the function returns NULL. If no match found, the function returns string_original without change.

SQL Replace Function Example

Table: Employees

Select all the employees, replace dev with development in Department:

SELECT EmployeeId
             , FirstName
             , LastName
             , REPLACE(Department, 'dev', 'development') AS Department
FROM Employees

The result will look like: