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