How to Replace String in SQL Server 3

How to Replace String in SQL Server

How to Replace String in SQL Server table column with example? For this Interview Question, We are going to use the below-shown data.

Source Table 1

Replace String in SQL Server Example

In this replace string example, we will declare a string variable and then replace a part of a string with a new string using the Replace Function.

DECLARE @String_Expression varchar(50)
SET @String_Expression = 'Blog Provides Free Tutorial on SQL Server'

SELECT REPLACE (@String_Expression, 
                'Blog','Tutorial Gateway'
                ) AS 'SQL Server Replace'
Replace String 2

 This example shows how to replace a string in the SELECT Statement. Here we are going to use the REPLACE Function while we are selecting data from the SQL Server table.

SELECT [EmpID]
      ,[Full Name]
      ,[Education]
      ,[Occupation]
      ,[YearlyIncome]
      ,[Sales]
      ,[Email Adress]
      ,REPLACE([Email Adress], 'microsoft.com', 'tutorialgateway.org') AS [New EmailID]
  FROM [StringExample]
How to Replace String in SQL Server 3

Example 3

In this example, we will show you, How to replace strings in an UPDATE Statement. Here we are going to use the REPLACE Function in Update Statement.

UPDATE [StringExample]
SET [Email Adress] = REPLACE([Email Adress], 'xyz.com', 'tutorialgateway.org')
Output 4