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: How to search a string

Re: How to search a string

From: Noodles <noodles_at_aol.com>
Date: 06 Jan 2002 00:34:24 GMT
Message-ID: <20020105193424.05434.00000528@mb-mr.aol.com> 





Look into the INSTR function to find where the comma is.  Then use that output 
( less 1 char) with the SUBSTR function.  That should give you name1.  Once you
know where the comma delimiter is you can now find name2.



Cliff
Received on Sat Jan 05 2002 - 18:34:24 CST












Original text of this message













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