Use the ASCII code in stead of character in string

When I am filtering my query on names I'm getting errors due by quotes. For example, I am looking for: Charles d'Ancona
I put this in the query which gives an error.
where in ('Charles d'Ancona')
I've tried to replace it with
where in ('Charles d' || char(39) || 'Ancona')
But that doesn't work either.
Who has a solution?

Hi @tictac
Please post "Diagnostic Info" from Admin > Troubleshooting, and which database you are querying.
In some databases you escape a single-quote by adding another single-quote 'Charles d''Ancona'