Replacing characters with specified one

Question

Hello All,

I have a string as follows - MFMFMF

now i want to change this string to FMFMFM how to do this , help needed pls

i had tried

select replace(replace('mfmfmf','M','F'),'F','M') this gives me result - MMMMMM which i donot what i want the output to be FMFMFM Need your help

D.Mahesh

Answer 1

Try:

select replace(replace(replace('mfmfmf', 'm', 'x'), 'f', 'm'), 'x', 'f') ...

It's because your first replace yields:

ffffff

And then replacing fs with ms, yields mmmmmm. You need an intermediary replace.

Answer 2

select replace(replace(replace('mfmfmf','M','X'),'F','M'),'X','F')