SQL SERVER REPLACE FORMULA

SQL SERVER REPLACE FORMULA

-- THEORY

-- SELECT REPLACE([COLUMN],'VALUE','REPLACEMENT VALUE') AS [COLUMN ALIAS NAME], *

-- FROM [DATABASE NAME].[DATABASE OBJECT].[TABLE NAME] AS [TABLE ALIAS NAME];

-- EXAMPLE

SELECT REPLACE(PC.EnglishProductCategoryName,'Bikes','Bike') AS [DISPLAY REPLACEMENT FOR BIKES TO BIKE], *
FROM AdventureWorksDW2012.dbo.DimProductCategory AS PC;