I always back away from these stupid delimiter problems by replacing quotes
and apostrophes with upper-ascii characters that look like them (chr$(146)
and chr$(148), for example). But I'm sick of the CPU drag that all the
So, I'm looking for THE definitive query delimiter sequence I can use with a
Jet database that will allow me to manipulate text fields regardless of
These are examples of the titles in a music database:
Fool on the Hill
Scherzo from "A Midsummer Night's Dream"
Note that there will be combinations of quotation marks and apostrophes. I
have never found a way to handle all of the above.