TRANSLATE function in SQL SERVER

Question

I read that there is a function equivalent to the standard function TRANSLATE under DB2 under SQL Server 2017. But how to do under earlier versions?

Answer 1

I learned that there is a functional equivalent to the regular function TRANSLATE under DB2 under SQL Server 2017.  And We can easily use the TRANSLATE function in SQL SERVER. 

Using below code:

DECLARE

  @string varchar(7000)  = 'xyz',

  @fromChar varchar(200) = 'xyz', -- note: no mutation

  @toChar varchar(100)   = 'yza';

SELECT newString = 

(

  SELECT CASE WHEN x>z THEN '' WHEN x>0 THEN s ELSE t END+''

  FROM dbo.ngrams8k(@string,1) ng

  CROSS APPLY (VALUES (charindex(ng.token,@fromChar),len(@toChar),ng.token)) x(x,z,t)

  CROSS APPLY (VALUES (ng.position, substring(@toChar,x.x,1))) xx(p,s)

  ORDER BY xx.p

  FOR XML PATH(''), TYPE

).value('(text())[1]', 'varchar(8000)');

Returns > yza