Equivalent to Oracle TRANSLATE function in Microsoft SQL Server
What is the equivalent to Oracle PL/SQL TRANSLATE function in Microsoft SQL Server T-SQL?
TRANSLATE returns string with all occurrences of each character in from_string replaced by its corresponding character in to_string, both of these strings are being passed as parameters to TRANSLATE. For example,
TRANSLATE('big brown cow', 'abc', 'xyz') /* this would return 'yig yrown zow' */
This function is useful in many situations, for example,