Searching Text in words

From: <>
Date: Wed, 8 Oct 2008 06:40:29 -0700 (PDT)
Message-ID: <>


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

Original text of this message