Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: A substr question

Re: A substr question

From: Jonathan W. Ingram <jingram_at_spam.less.teleport.com>
Date: Fri, 15 May 1998 17:59:07 GMT
Message-ID: <355c8236.6991739@news.teleport.com> 





On Fri, 15 May 1998 03:26:20 GMT, hughesguy_at_my-dejanews.com wrote:



>In article <6jdoh6$bdg5_at_hkpa05.polyu.edu.hk>,


>UPDATE TEST SET COL2 = to_number(SUBSTR(COL1,1,1));


This seems to be the generic solution posted so far. However, it will
only work if the first character of the value in COL1 is a number.
Otherwise, you will still be receiving an invalid number error.



Jonathan Ingram

Received on Fri May 15 1998 - 12:59:07 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US