REPLACE
Replaces all occurrences of characters in a string with another set of characters.
Behavior Type
Syntax
REPLACE ('string', 'target', 'replacement' )
Parameters
string |
The string to modify. |
target |
The characters in string to replace. |
replacement
|
The characters to replace target. |
Examples
=> SELECT REPLACE('Documentation%20Library', '%20', ' '); REPLACE ----------------------- Documentation Library (1 row)
=> SELECT REPLACE('This & That', '&', 'and'); REPLACE --------------- This and That (1 row)
=> SELECT REPLACE('straße', 'ß', 'ss'); REPLACE --------- strasse (1 row)