How and in what way REPLACE is different from TRANSLATE?

zahar

 Profile Answers by zahar Questions by zahar

• Jun 10th, 2011

REPLACE : replace function is: replace( string1, string_to_replace, [ replacement_string ] )string1 is the string to replace a sequence of characters with another set of characters.string_to_repl...

sandip88

 Profile Answers by sandip88 Questions by sandip88

• Feb 9th, 2010

Translate does character by character substitution,where replace can substitute a singele character with a word

Answer Question  Select Best Answer

Maria

• May 16th, 2017

With GROUP BY statement.

Palak

• Apr 20th, 2017

By using Unique Command

Answer Question  Select Best Answer