How to Replace String in SQL Server table column with example?. For this SQL Server Interview Question, We are going to use the below-shown data
Replace String in SQL Server Example 1
In this replace string example, we will declare a string variable, and then we are going to replace a part of a string with a new string using the Replace Function.
-- SQL Server Query to Replace String 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 Example 2
This example shows how to replace a string in SELECT Statement. Here we are going to use the REPLACE Function while we are selecting data from the SQL Server table.
-- SQL Replace Part of a String USE [SQL Tutorial] GO SELECT [EmpID] ,[Full Name] ,[Education] ,[Occupation] ,[YearlyIncome] ,[Sales] ,[Email Adress] ,REPLACE([Email Adress], 'microsoft.com', 'tutorialgateway.org') AS [New EmailID] FROM [StringExample]
Replace String in SQL Example 3
In this example we will show you, How to replace string in SQL UPDATE Statement. Here we are going to use the REPLACE Function in Update Statement.
-- SQL Replace Part of a String USE [SQL Tutorial] GO UPDATE [StringExample] SET [Email Adress] = REPLACE([Email Adress], 'xyz.com', 'tutorialgateway.org')