|
|
|
|
|
|
Replace all occurrences in string of substring from with substring to
Syntax
REPLACE ( string , target , replacement )
Semantics
string |
(CHAR OR VARCHAR) is the string to which to perform the replacement |
target |
(CHAR OR VARCHAR) is the string to replace |
replacement |
(CHAR OR VARCHAR) is the string with which to replace the target |
Examples
> SELECT REPLACE('Documentation%20Library','%20',' ');
replace
-----------------------
Documentation Library
(1 row)