Re: Searching Text in words

From: zien <>
Date: Thu, 9 Oct 2008 04:51:43 -0700 (PDT)
Message-ID: <>

On Oct 8, 3:40 pm, 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