The translate function replaces the characters in a string with the new set of characters one by one. For example:- the first character in the string is replaced by the first character of the original string and so on. The translate function always returns a string value.

BY Best Interview Question ON 19 Feb 2019

Example

Syntax:-

TRANSLATE( string1, string_to_replace, replacement_string )

String1:-the string which has to be replaced

string_to_replace:-the string that has to be searched in the string 1

replacement_string:-the new string with which string1 will be replaced.