Replacing characters with specified one
- by mahesh
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