1 Reply Latest reply on Jun 18, 2009 4:42 AM by kevinUCB

    Search for a reserved word?

    Catfive Lander
      Can I make Oracle Text do a search for a reserved word?

      I've got users searching for 'not well' and 'forget me not', and although I've trapped that and wrapped the word in braces (so the searches are passed as ...contains(searchfield,'({not}) and well')>0, for example), the results show a lot of very healthy people and holes in the ground with water in them: only the 'well' bit is being recognised, it seems.

      Similarly, 'forget me not' is being searched as 'forget and me', with the 'not' bit seemingly being ignored.

      Can I get a 'not', when the first or last word in a search, to be searched for as that word?