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.

REPLACE(x,y,z)
x, y, z	Result of the REPLACE(x,y,z) function
`REPLACE(x,y)`	The character string `y` is deleted in `x`
`x` is a NULL value	`NULL` value
`y` is a `NULL` value	x remains unchanged
`z` is a `NULL` value	The character string `y` is deleted in `x`

Example

SQL Tutorial, Changing Character Strings

More Information

TRANSLATE(x,y,z)