How do I deal with punctuation after a WHERE part of a query? 2

[mage]

Say I have a Query:
SELECT id FROM Students WHERE (Sponsor='markham's')
The middle appostrophy causes a cut off and error in the query in Access. How do I deal with such problems?

 

[tlbroadbent]

Two ways to handle problem. I prefer the 1st way in Access.

Use double quotes to delimit text.
SELECT id FROM Students WHERE (Sponsor="markham's&quot

Use two consecutive single quotes to represent one in a string.
SELECT id FROM Students WHERE (Sponsor='markham''s')

Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin