Re: ignore keywords in the CONTAINS??

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}.

--
Andy Hassall <andy_at_andyh.co.uk> / Space: disk usage analysis tool
http://www.andyh.co.uk         / http://www.andyhsoftware.co.uk/space