RE: how to substr '%' from the data?

From: MacGregor, Ian A. <ian_at_SLAC.Stanford.EDU>
Date: Mon, 11 Jun 2001 15:29:57 -0700
Message-ID: <F001.00324BC1.20010611153545@fatcity.com>

By
using the instr function.   Here is an example.  N.B., the  space between the  words "and"  and "seven" is returned.
 
 
    select substr('Four score and seven years
ago',1,   instr('Four score and seven years ago', 'seven') -1)  from dual
 

<FONT face=Arial color=#0000ff
size=2>SUBSTR('FOURSCO---------------Four score and
 
 

Ian
MacGregor
<FONT face=Arial color=#0000ff
size=2>Stanford Linear Accelerator Center <A
href="mailto:ian_at_slac.stanford.edu">ian_at_slac.stanford.edu

  <FONT
  size=2><FONT face=Arial
  color=#0000ff> 
  <FONT
  size=2> 
  <FONT
  size=2> -----Original
  Message-----From: Helen rwulfjeq
  [mailto:lannyue_at_yahoo.com]Sent: Monday, June 11, 2001 4:07   PMTo: Multiple recipients of list ORACLE-LSubject: how   to substr '%' from the data?
  Hello,
  I have data like following, how do I substr the string (or use any other   function) to get until "%" and return without "%":

  *************************************<FONT 

  face=Courier>

  RC-SF-DAL-nd-% 
  AD-LE-%-%-% 
  RC-DD-LKF-01-RENTAL%
  CS-%-%-%-% 
  CS-%-ABC-%-% 
  *************************************

  I did  "select RTRIM('CS-%-%-%-%', '%-%') from DUAL",   but it can not return correct for the last record   eg,  "select RTRIM(CS-%-ABC-%-%', '%-%') from   DUAL"  -- will not work correctly
   
  Thanks for help
         

  Do You Yahoo!?<A
  href="http://personal.mail.yahoo.com/?.refer=mailiyfoot">Yahoo! Mail Personal   Address - Get email at your own domain with Yahoo! Mail. Received on Mon Jun 11 2001 - 17:29:57 CDT