Re: A substr question

Try using TO_NUMBER .

Alexander I. Doroshko wrote:

> Probably, you have some records where first symbol
> of COL1 isn't a digit. Check it.
>
> Elton Chan <97980015r_at_polyu.edu.hk> wrote in article
> <6jdoh6$bdg5_at_hkpa05.polyu.edu.hk>...
>
> > anybody can help, I come across a problem while using the
> following
> sql
> > that for data extraction.
> >
> > UPDATE TEST SET COL2 = (SUBSTR(COL1,1,1));
> > *
> > ERROR at line 1:
> > ORA-01722: invalid number
> >
> > while COL2 is number(1) and COL1 is Char(4) like 2X.9 or 6K.0 that I
> want
> to
> > extract the first number i.e. 2 and 6 from COL1 to COL2.
> ---
> Alexander I. Doroshko, Bank "Grant", Ukraine
> aid_at_grant.kharkov.ua
Received on Tue May 26 1998 - 13:30:10 CDT