how to substr '%' from the data?

From: Helen rwulfjeq <lannyue_at_yahoo.com>
Date: Mon, 11 Jun 2001 14:56:00 -0700
Message-ID: <F001.00324ACF.20010611150636@fatcity.com>

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. Received on Mon Jun 11 2001 - 16:56:00 CDT