Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Intermedia - escaping words 1

Status
Not open for further replies.

Ezequiel

Programmer
Apr 4, 2001
30
CA
I need to find a record that contains, for example the "NT" and the "UNIX" words.
So, I do a kind of:

.... where contains (COLUMNAME, 'UNIX and NT', 10)>0...

The problem: the OCI Routine thinks that I'm speaking about NT = narrower term (usage: NT(dog, cat)) so I receive an error.

Is there a way to "escape" these term so that I can really search for "UNIX and NT"?

Thanks in advance.
 
enclose the the terms in {}

contains(column_name,'{UNIX} and {NT}')>0

--Jeff
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top