Re: A substr question

From: joachim Carlsson <IKEA-joachim.carlsson_at_neurope.ikea.com>
Date: Thu, 14 May 1998 13:46:54 +0200
Message-ID: <6jelpa$1sh$1@mailgate.ikea.com>

You can only substring chars.

you have to do a to_char first then to_number to get the format back again.

/Joachim
Elton Chan <97980015r_at_polyu.edu.hk> wrote in message <6jdoh6$bdg5_at_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 Thu May 14 1998 - 06:46:54 CDT