CODEWITHSUNDEEP
sqlms-accessquotation-marks
Canned Man
Canned Man

Reputation: 766

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

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!

Upvotes: 0

Views: 2110

Answers (1)

Nebi
Nebi

Reputation: 326

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 '

Upvotes: 2

Related Questions