Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'
Solved:
The best I could come up with is the replace the apostrophe with an ` chr(96)
Looks pretty close and doesn't fail.
Solved:
The best I could come up with is the replace the apostrophe with an ` chr(96)
Looks pretty close and doesn't fail.