I need a sql query that will search and replace the following string of text inside a field in my database table. I want to replace the string ' with the single quote character. Right now, I have a bunch of LastName fields that look like this:
Again, I just want to get rid of that HTML equivalent and use the literal single quote character instead.
TIA for assistance in constructing this query!