Re: A substr question

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 19 1998 - 03:52:36 CDT