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.

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

Examples

SQL Tutorial, Changing Character Strings

 

See also:

TRANSLATE(x,y,z)