A substr question

From: Elton Chan <97980015r_at_polyu.edu.hk>
Date: Thu, 14 May 1998 11:23:28 +0800
Message-ID: <6jdoh6$bdg5@hkpa05.polyu.edu.hk>

Hi all,

    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.

Anybody help???

Thanks,
Elton Received on Wed May 13 1998 - 22:23:28 CDT