Thanks Sybrand,
Implicit in my question was "How to simulate the VAL function"
Have you got any idea on that?
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<tr1gfllaimdt1e_at_news.demon.nl>...
> "Oli" <SSI_95270_at_yahoo.fr> wrote in message
> news:720ded81.0109250542.73c5f1cd_at_posting.google.com...
> > Hello,
> > there is a function in VB call VAL allowing
> > to retrieve only first numeric value of a string.
> >
> > E.g.
> > A=75h87 Val(A)=75
> > B=985 Val(B)=985
> > C=9874R Val(C)=9874
> > D=3Y87U Val(D)=3
> >
> > Does this function exist in PL/SQL ?
> >
> > Thanks
>
> No
>
> The sql reference manual would have told you that.
>
> Regards,
>
> Sybrand Bakker, Senior Oracle DBA
Received on Wed Sep 26 2001 - 04:30:38 CDT
