Apostrophe in string search

[Doc Thirst]

I'm trying to find records containing an Apostrophe in the name. Any suggestions, I'm working in the console and everything returns an error. I've tried a variety of options, like ['], "'", '\'' to name a few.

[Doc Thirst]

Did the trick:

WHERE (LAST_NAME LIKE '%''%')