Cleaning Database Field Script "O'Connell"

I have fields like these in my database:

O'Connell

I would like to write a sql statement that would eliminate backslashes from the first and lastname fields.

How can I do this?