How to Escape an Apostrophe in CEQL

If you need to write a CEQL query that has an apostrophe—for example, if you need to write a query to search for the last name equal to O'Moore—you can do so by adding an additional apostrophe (single quote) before the character you are trying to escape.

For example:

LastName='O'Moore'

would become

 LastName='O''Moore'