REPLACE(x,y,z)

Use

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
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)