TRANSLATE(x,y,z) 

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

	Result of the TRANSLATE(x,y,z) function
x is a NULL value	NULL value
y is NULL value	x remains unchanged

Examples

SQL Tutorial, Changing Character Strings

 

See also:

REPLACE(x,y,z)