Re: Searching Text in words

From: zien <tldarwish_at_gmail.com>
Date: Thu, 9 Oct 2008 04:51:43 -0700 (PDT)
Message-ID: <8eb1f398-297b-4b20-a7a8-43eb5b4a723e@t39g2000prh.googlegroups.com>


On Oct 8, 3:40 pm, artme..._at_yahoo.com wrote:
> 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?

hi can u help me Received on Thu Oct 09 2008 - 06:51:43 CDT

Original text of this message