translate
Returns "string_expression1" in which characters from "string_expression3" are translated to the equivalent characters in "string_expression2". "String_expression4" is a single character that is used to pad "string_expression2" if it is shorter than "string_expression3". If only "string_expression1" is present, then this function translates it to uppercase characters.
Syntax
translate ( string_expression1 [ , string_expression2,
string_expression3 [ , string_expression4 ] ] )
Example 1
translate ( 'abcdefg' )
Result
Returns ABCDEFG.
Example 2
translate ( 'mnlop' , n, m , - )
Result
Returns n-nlop.