SQL REPLACE() Function

SQL REPLACE() Syntax

The below syntax is used to replace strings from a given input string or expression.

SELECT REPLACE(string1, find_character_or_string, replace_character_or_string);

The below syntax is used to replace strings from a in a specific column value.

SELECT REPLACE(column_name1, find_character_or_string, replace_character_or_string) FROM table_name;

SQL REPLACE() Example - Using Expression Or Formula

The following SQL SELECT statement replace sequence of characters or a string within a string.

SELECT REPLACE('Sql Tutorial.', '.', '!') AS 'Replaced String';

The result of above query is:

Sample Database Table - Employee

SQL REPLACE() Example

The following SQL statement replace the "EmpName" and "Dept" column from the "Employee" table:

SELECT ID, 
EmpName, REPLACE(EmpName, 'a', '@') As 'Replaced - EmpName',
Dept, REPLACE(Dept, 'PHP', 'Personal Home Page') As 'Replaced - Dept' 
FROM Employee;

The result of above query is: