SQL REPLACE Function

The SQL REPLACE is one of the SQL String Function, which is used to replace the existing string with new string value. In general, REPLACE Function return VARCHAR output but if one of the input value is NVARCHAR then, it will return NVARCHAR output

Syntax of a REPLACE in SQL

The basic syntax of the REPLACE in SQL Server is as shown below:

• String_Expression: Please specify the valid string to perform search. Replace function will replace portion of a string present in this String_Expression.
• String you want to change: Please specify the valid string you want to change. Whatever you place here, REPLACE Function will be replace it by new string
• Replacing_String: Please specify the valid new string you want to insert into String_Expression.

In this article we will show you, How to write REPLACE Function in SQL Server 2014 with example. For this, We are going to use the below shown data

SQL REPLACE Function Example 1

The REPLACE Function simply replaces the original string with specified new string. The following query will show multiple ways to use Replace function.

T-SQL CODE

OUTPUT

ANALYSIS

Below lines of code is used to declare string variable and assigning the string data.

In below statement, We used REPLACE function to replace the T-SQL with SQL from the variable @String_Expression. We also assigned new name to that result as ‘SQL Replace’ using ALIAS Column.

In the next line, We used REPLACE function to replace the T-SQL with SQL from ‘Learn T-SQL Server 2014’ string directly

SQL REPLACE Function Example 2

The REPLACE function also allows you to replace the column values. In this example,We are going to replace the .com with .org from Email column

T-SQL CODE

OUTPUT

REPLACE in SQL Example

In this example, We are going to replace the @ symbol present in Email column with Empty space using REPLACE function

T-SQL CODE

OUTPUT

Thank You for Visiting Our Blog