i'm trying to do this query:
WHERE value1='THIS'S AN EXAMPLE'.
Try escaping it like that:
SELECT * FROM TABLE WHERE value1='THIS''S AN EXAMPLE'
'' is 2 single quotes.
But best would be to make this a parametrized query. If you're running it from your code.