Does any one know if it is possible to have SQL strings to access data, where the data in question might contain both a " and a '?

I have been using chr(34) but that doesn't work when there is a " in the data itself. For instance, I wanted an INSERT query that would insert 3015 "J" Street into the Address table.

Any help or suggestions would be appreciated.

Mike

Mike
EchoVue.com

__________________
Mike
EchoVue.com

Why do you need quotes around the J in "J" Street? Put those in your report formatting later.

In Access, I use "'" to pass single quotes in SQL criteria, like this:

stValue = "MyValue"
stLinkCriteria = "[FieldName] = " & "'" & stValue & "'"

It is passed to look like this:

[FieldName] = 'MyValue'

I hope this gets you started.


mmcdonal

Thanks. The problem is that I am working with about 18000 records which have been entered in by end users over the past 15 years. I guess that just felt that they should put the odd ' and " in to make my job more interesting.

I had been using "'" to get the quotes in, but then got hung up on O'Brien and so I have started using chr(34) instead. Do you know if there are escape sequences that can be used in VBA, like Java and C++? If not, I may have to parse the data before moving it into a different table.

Thanks

Mike
EchoVue.com