Solution to TSQL Beginners Challenge 23

DECLARE @t TABLE(
          Data VARCHAR(20),
          DataToReplace VARCHAR(100),
         ReplacedWithData VARCHAR(100))

INSERT INTO @t
seLECT 'Cap','cp','xy'

SELECT * FROM @t

SELECT DATA AS ORIGINAL,REPLACE(REPLACE(DATA,SUBSTRING(DataToReplace,1,1),SUBSTRING(ReplacedWithData,1,1)),SUBSTRING(DataToReplace,2,1),SUBSTRING(ReplacedWithData,2,1)) AS EXPECTED from @t 

Since we know the length of data here i did it. Is there any code if the length varies dynamically?

Tags: