Re: How to get the part of the string?

Roger Stapley <roger.stapley_at_oracle.com> wrote in message news:<3C03C898.F5D0F08B_at_oracle.com>...
> SELECT SUBSTR('abcdef&123', INSTR('abcdef&123',CHR(38),1)+1, 100)
> FROM DUAL ;
>
>
> "??????????????? wrote:
>
> > Hi guys!
> > I need your help.
> > I have the following string :
> > 'abcdef&123'
> > Is it possible to retrieve the part of the string after '&' character,
> > using one statement?
> >
> > Thanks in advance.
> > Alex
>
> --

This won't work as if the string doesn't contain a '&' it returns the whole string... he won't be able to_number it. Received on Thu Nov 29 2001 - 11:57:46 CET