Starting with SQL Server 2017, you can now use the T-SQL TRANSLATE()
function to translate one or more characters into another set of characters.
At first glance, you might think that the TRANSLATE()
 function does exactly the same thing as the REPLACE()
 function, but there are significant differences between the two.