Function documentationREPLACE(x,y,z) Locate this document in the navigation structure


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


SQL Tutorial, Changing Character Strings

More Information