Hi Everybody,
I have a problem about the single quotation mard ' in SQL statement because my data may contain the single quotation mark. For example, a city called Saint-Leonard-D'Aston. If this kind of data occurs, my query gets error message because the query treats the mark as a operator to enclose a string.
How can I make the query know that the single quotation mark is part of string, not to enclose a string?
Thanks a lot.
James
