Question: I have a data base that has some single quotes in the field EX: new''car. I want to query the data base to locate (and replace) these single quotes but for the life of me can't remember how to include them in a search string
such as: select * from database where field like '%''%' which of course wont work. I also want to replace these quotes with nothing so using the example above it would be new''car replace with newcar.