Quatation mark or single mark in sql query

Hello,

I am trying to run sql query in VBA.
Some of the condition values contain single quate sign or
quatation mark, so I get an error (Missing operator) when I try to run the query.

Example:
... OR [Name] = 'AB'C' ...
... OR [Name] = "AB"C" ...

My data contain both single quate and quatation marks.

How should I declare sql query ?

Thank you

Double up the apostrophe ...

Please Login or Register  to view this content.