Problem with where clause when names have an apostrophe

dgreenberg — Thu, 24 Mar 2016 17:22:08 GMT

I am trying to pass ePartner to a where a clause.

Resident Sampling1

where ePartner <> '[O'Mara,Jane J]';

I have tried brackets, double quotes and everything else I can think of.

I am currently using this

Let vPartnerB=chr(39) & chr(91) & peek('ePartner',$(vRand),'Sampling2') & chr(93) & chr(39);

But that fails when the name has an apostrophe as shown above.

I guess let's keep it simple and say how can I use a where clause with a name with an apostrophe

where ePartner <> 'O'Mara, Jane J'

dgreenberg — Thu, 24 Mar 2016 18:34:30 GMT

Solved:

The best I could come up with is the replace the apostrophe with an ` chr(96)

Looks pretty close and doesn't fail.