The CONVERT function converts individual characters.
Format
|
NEW=CONVERT(Original,String1,String2) |
Description
CONVERT( ) returns a modified version of the original string, with each character found in String1 converted to the character in the same position in String2.
It is perfectly acceptable for String2 to be null or a different length from String1. Where there is no corresponding character in String2, the character in String1 is deleted. Additional characters in String2 are ignored.
See Also