Re: Searching Text in words
Date: Wed, 8 Oct 2008 11:39:37 -0700 (PDT)
On Oct 8, 9:13 am, artme..._at_yahoo.com wrote:
> On Oct 8, 8:50 am, yossarian <yossaria..._at_operamail.com> wrote:
> > artme..._at_yahoo.com wrote:
> > > 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.
> > Did you check out if REGEXP_LIKE is suitable for your needs?
> > Kind regards,
> > Y.
> REGEXP_LIKE does not seem to have anything that would search at the
> beginning of every word, including the first word.
I'm very rusty on regexp, but can't you say "the first word starting with B or a space followed by a B" with something like ^B|\ B
-- @home.com is bogus. http://search.twitter.com/search?max_id=923642731&page=6&q=%23inventedReceived on Wed Oct 08 2008 - 13:39:37 CDT