Searching on wildcards using db.FTSearch

The following fails because of the question mark. A question mark is a wildcard along with a few other characters.

query = “Is this a nice day? Fred”

Set searchDb = DbSearch.FTSearch( query, maxDocs )

How can I include a question mark in my query and return the results I’m after?

Subject: have you tried putting it in quotes ?

instead of:

query = “Is this a nice day? Fred”

Set searchDb = DbSearch.FTSearch( query, maxDocs )

try:

query = |“Is this a nice day? Fred”|

Set searchDb = DbSearch.FTSearch( query, maxDocs )

or

query = “‘Is this a nice day? Fred’”

Set searchDb = DbSearch.FTSearch( query, maxDocs )

Subject: Nope, no go, doesn’t work in the view search bar either