Re: return first token/word from string?

jobs wrote:
> I'm on Oracle 9i. Is there any built in function that would return the
> first token or string from a string?
>
> For example, given string = " bob lfcr bill"
>
> I want to return "bob"
>
> imediately following bob there might be cases where we have a linefeed/
> cr.
>
> Thanks for any help or information.

Look at REGEXP_SUBSTR
http://www.psoug.org/reference/regexp.html#rerp

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org