TRANSLATE(x,y,z)

Use

TRANSLATE(x,y,z) is a string function which replaces the i th character in the character string y with the i th 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

Example

SQL Tutorial, Changing Character Strings

More Information

REPLACE(x,y,z)