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
Bookmarks