Thanks a lot, that works.
"MacGregor, Ian A." <[EMAIL PROTECTED]> wrote:
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 dualSUBSTR('FOURSCO
---------------
Four score andIan MacGregorStanford Linear Accelerator Center-----Original Message-----
From: Helen rwulfjeq [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 11, 2001 4:07 PM
To: Multiple recipients of list ORACLE-L
Subject: 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 "%":
*************************************
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!?
Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.
Do You Yahoo!?
Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.