A Sring Contains a Single Quotation Mark

[jamesjing]

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

[chrisjk]

You have to double single quotes up, like ' becomes ''

Something like this

strstring = Replace(strstring, "'", "''")