Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ignore keywords in the CONTAINS??

Re: ignore keywords in the CONTAINS??

From: travis <travis_brooks_at_hotmail.com>
Date: 21 Jun 2004 14:42:47 -0700
Message-ID: <c79acf51.0406211342.847280d@posting.google.com>


Just what i was looking for, thanks.

-travis

Andy Hassall <andy_at_andyh.co.uk> wrote in message news:<mv98d01j7vm2q6t0h7oig90hov88m1t20o_at_4ax.com>...
> On 18 Jun 2004 11:36:20 -0700, travis_brooks_at_hotmail.com (travis) wrote:
>
> >We have been trying to figure out how to get the contains function to
> >recognize an input like:
> >
> >"DOES NOT OPERATE"
> >
> >where it treats the "NOT" as a word to search for, not interpretting
> >it as a special ~ operator.
> >
> >we're using oracle version 9.2.0.4.
>
> Enclose literals in curly brackets, i.e. {DOES NOT OPERATE}.
Received on Mon Jun 21 2004 - 16:42:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US