S.no REPLACE() TRANSLATE()
1. It replaces the complete string at once It replaces the character one by one
2. If no match is found, then it returns the string If no match is found, then it returns the NULL value.
3. REPLACE( string1, string_to_replace [, replacement_string] ) TRANSLATE( string1, string_to_replace, replacement_string )

Suggest An Answer

No suggestions avaliable!