The CONVERT statement converts one or more characters in a string to their corresponding replacement characters.
CONVERT expression1 TO expression2 IN expression3
expression1 is the list of all characters to translate in expression3.
There is a one to one correspondence between the characters in expression1 and expression2. That is, character 1 in expression1 is converted to character 1 in expression2, etc.
See also the CONVERT function.