If you're trying to include a single quotation mark in a string, you have to escape it with another single quote. So your code would look something like:

delete from mytable

where myvar like '%''%'