Reference Guide > TDV Support for SQL Functions > Character Functions > TRANSLATE
 
TRANSLATE
Returns the string from the first argument AFTER the characters specified in the second argument are translated into the characters specified in the third argument:
Syntax
TRANSLATE(string, characters, translations)
Example
SELECT TRANSLATE('Product', 'Product', 'Order');
Returns: Order