Searching Text in words
From: <artmerar_at_yahoo.com>
Date: Wed, 8 Oct 2008 06:40:29 -0700 (PDT)
Message-ID: <6224a6b5-d15c-4723-abac-77decd3674e0@y79g2000hsa.googlegroups.com>
Date: Wed, 8 Oct 2008 06:40:29 -0700 (PDT)
Message-ID: <6224a6b5-d15c-4723-abac-77decd3674e0@y79g2000hsa.googlegroups.com>
Hi,
I need to be able to search some text, basically company names, and I'm only looking to match on the first letter of each 'word'. So, if I was looking for B then International Business Machines would give me a match on the letter B in Business. If I was looking for 'N', then I would not get any match at all.
If I put in Bu, I'd get a match on Best Buy, but not Lehman Brothers.....
I was looking at Oracle Text, but I think that is a bit much and complex for this application. I can parse each name on spaces and such and try it that way, but I was wondering if Oracle had a better way of doing it.
We are on 10g R2.
Still searching, but has anyone ever done this? Received on Wed Oct 08 2008 - 08:40:29 CDT