Replace NOT working!

Question

I have column with values that have wrong character ?. Now I want to change it to character b. For this I am using this statement:

SELECT REPLACE(name,'?','b') from contacts;

But when I do this nothing's happening, it return value with ?.

What I am doing wrong? How I can replace this?

Answer 1

Another possibility that I've seen before is that the character looks like a regular old ASCII question mark but it's not really. It's actually a different character. I'd select the text and paste it into Notepad and then copy and paste it into my query.