Re: ignore keywords in the CONTAINS??

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.
>
> thanks
>
> -travis brooks

can we see how it is represented in the code?

I would guess you are trying to do something like:

select a from b where a contains 'DOES NOT OPERATE';

try using like to see if you get the same results:

select a from b where a like '%does not operate%';

Are you getting an error message (if so, what is it??)

If this persists, you might submit TAR to see if this expected behavior I would think that this is a bug -- anything inside the quoted string should be treated as text not an operator. Note the single tick-marks.

Michael Austin.
DBA Consultant. Need one?? Received on Fri Jun 18 2004 - 15:26:05 CDT