CONTEXT Options

From: Ed Jennings <jenningse_at_mindspring.com>
Date: 1998/03/10
Message-ID: <350604DD.580C_at_mindspring.com>#1/1


I'm running Oracle 7.3.3 with the context option. I have a LONG column that contains ascii text. Within the data is embedded phone numbers with and without embedded formatting (i.e. "123-456-7890" and/or "1234567890").

Searches with CONTAINS '456' would locate the first form only.
Searches with CONTAINS '1234567890' would locate the second form only.
Searches with CONTAINS '123-456-7890' would not locate any rows.

I'm using all default values when I set up my POLICY. Are there any options that I can use to cause searches to be a little more flexible? In the example above, I'd like a search on '456' to return both of those rows as hits.

TIA
Ed Jennings

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~
jenningse_at_mindspring.com

"The opinions expressed here are my own, not those of DOMAIN
technologies"
Received on Tue Mar 10 1998 - 00:00:00 CET

Original text of this message