TRANSLATE(x,y,z)
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 |
|---|---|
|
|
|
|
SQL Tutorial, Changing Character Strings