Verity searches and reserved words

Has anyone got some solid logic on handling reserved words for verity searches?
Searching for Portland, OR will cause a cfcatch, whereas "Portland,'OR" will return the desired results.

From what I can tell, AND, OR, and NOT are reserved words.  But sometimes they're used as part of a literal string, and other times they're used as operators.  So, I dont think I want to just do some sort of global replace.

Anyone have any ideas here?
LVL 7
aseusaincAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

eszaqCommented:
To search for a literal AND, OR, or NOT, enclose the literal term in double quotation marks; for example:
love "and" marriage. I am afraid this is the only way. The problem is to determine if your user meant state of Oregon or actual boolean operator "OR". There is no easy answer without putting some limitations. You might have search form as a set of text-inputs with select drop-downs between them (options: AND, OR) and unless OR is coming from boolean select escape is with double-quotes.

Another option - put up on your  website extensive verity search help page. Downside - very few average users are savvy enough to "unleash the power of boolean expressions"

Sorry for bad news... Please don't kill the messenger :0)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
aseusaincAuthor Commented:
Never did find any alternative.  eszaq is correct, it's just the way it is...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Servers

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.