Re: Searching Text in words

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

jg

--
@home.com is bogus.
http://search.twitter.com/search?max_id=923642731&page=6&q=%23invented