REPLACE(x,y,z)
REPLACE(x,y,z)
is a string function that replaces the character string y
in
the character
string x
with the character string z
.
All character strings are string specifications. Only expressions that produce
an alphanumeric value are permitted as string specifications.
x, y, z |
Result of the REPLACE(x,y,z) function |
|---|---|
|
The character string |
|
|
|
x remains unchanged |
|
The character string |
SQL Tutorial, Changing Character Strings