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)