How do I search for words including quotation marks in Access/SQL

Question

I need to distinguish ‘"Omreisende"’ from ‘Omreisende’ in an SQL search. How do I write such a query? The solutions I have found thus far (such as this one), specifically try to circumvent the quotation mark, whereas I need to differentiate strings with them from those without them.

MS Access 2007 running towards an Oracle server.

Thanks in advance!

`Chr(34) ` is equivalent of `"` if you're using a macro. So it will be `Chr(34) & Omreisende & Chr(34) ` — FrozenFire, Sep 09 '16 at 06:31

score 2 · Accepted Answer · edited May 23 '17 at 12:32

2

In MS-Access you need to do it like this:

Quotation Marks in Access

[LastName] = """strName"""

In Oracle: Quotation Marks in Oracle

[LastName] = '''strName'''

So in MS-Access the Escape-operator is the double quotes " and in Oracle it is the single qoutes '

edited May 23 '17 at 12:32

Community

1
1

answered Sep 09 '16 at 06:30

Nebi

306
2
10

How do I search for words *including* quotation marks in Access/SQL

1 Answers1

How do I search for words including quotation marks in Access/SQL