Here is a port from the Oracle's TRANSLATE function to T-SQL.
It gets three arguments: a string to be searched, a string with a set of characters to be found and replaced, and another set of characters as the replacements.
Example:
SELECT dbo.TRANSLATE('ABCDE', 'BD', 'CE')
It will return 'ACCEE'.