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.

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)