TRANSLATE Function -- Syntax and Examples

TRANSLATE(string[, [table_out][, [table_in][, pad]]])

translate("abcdef")

returns the value "ABCDEF"

translate("abcdef","12","ec")

returns the value "ab2d1f"

translate("abcdef","12","abcd",".")

returns the value "12..ef"

UpperCase = translate(".abcdef".)

assigns the value "ABCDEF" to the variable UpperCase

Next