Question: what is difference between translate and replace?
Answer: The main difference is how each function deals with multiple characters. REPLACE() replaces one string with another string. ... TRANSLATE() on the other hand, replaces each character one by one, regardless of the order of those characters.