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


TRANSLATE(x,y,z) is a string function which replaces the ith character in the character string y with the ith character in the character string z within the character string x. The character strings y and z must have the same length.

x, y and z are string specifications. Only expressions that produce an alphanumeric value are permitted as string specifications.


x, y, z

Result of the TRANSLATE(x,y,z) Function

x is a NULL value

NULL value

y is a NULL value

x remains unchanged


SQL Tutorial, Changing Character Strings

More Information