![]() Previous |
![]() Next |
REPLACE
searches a string for a regular pattern, replaces it with another string, and returns the modified string.
Return Value
CHAR | NCHAR | VARCHAR2 | NVARCHAR2
Syntax
REPLACE(char, search_string [, replacement_string ])
Arguments
char
is the text expression that is searched.
search_string
is the text expression to search for.
replacement_string
is the text expression that replaces search_string
in char
.
Example
REPLACE('Nick Nack', 'N', 'Cl')
returns the string Click Clack
.