DECLARE @DATA VARCHAR(100) DECLARE @DataToReplace VARCHAR(100) DECLARE @ReplacedWithData VARCHAR(100) SET @DATA = 'Cap' SET @DataToReplace = 'cp' SET @ReplacedWithData = 'xy' DECLARE @START INT DECLARE @END INT SET @START = 1 SET @END = LEN(@DataToReplace) WHILE (@START <= @END) BEGIN SELECT @DATA = REPLACE(@DATA, SUBSTRING(@DataToReplace, 1, 1), SUBSTRING(@ReplacedWithData, 1, 1)) IF (@START > @END) BREAK; ELSE SET @START = @START + 1 END SELECT @DATA
Tags: