Searches and Apostrophe


RT 3.6.3

I’m trying to query tickets, using a custom field “Name”, but the name
contains an apostrophe. For example: o’reilly

When I click on Add and Search, no results are returned. When I click
on Edit, I get the following:

Error near ->reilly<- expecting a PAREN in ’ Queue = ‘General’ AND
’CF.{Name}’ LIKE ‘o’reilly’'
I’m lost

I’ve tried to escape the apostrophe, but this only allows me to apply
the change but the search remains the same.

Has anyone got the apostrophe to work in searches? If yes, how did you
get it to work?

Thank you,