TRANSLATE
Replaces individual characters in string_to_replace with other characters.
Behavior Type
Syntax
TRANSLATE ( string_to_replace , from_string , to_string );
Parameters
string_to_replace |
String to be translated. |
from_string |
Contains characters that should be replaced in string_to_replace. |
to_string |
Any character in string_to_replace that matches a character in from_string is replaced by the corresponding character in to_string. |
Example
=> SELECT TRANSLATE('straße', 'ß', 'ss'); TRANSLATE ----------- strase (1 row)