Hi all,
How to get rid off certain character from a string.
For example, I have string 'WC_89_06_03', what's an
easy way to get 'WC890603' out, is there a function?
Thank you in advance!
Janet
__
Do You Yahoo!?
Yahoo! Finance - Get real-time
Title: RE: How to get rid off certain character from a string ???
select replace(my_string,my_unwanted_chars) from dual
/
should do the trick ...
select replace('WC_89_06_03','_') from dual
/
Raj
__
Rajendra Jamadagni MIS, ESPN Inc
-L [EMAIL PROTECTED]
Subject: How to get rid off certain character from a string ???
Date: Fri, 06 Sep 2002 12:03:34 -0800
Hi all,
How to get rid off certain character from a string.
For example, I have string 'WC_89_06_03', what's an
easy way to get 'WC890603' out, is there a function?
Thank you
, September 06, 2002 4:04 PM
To: Multiple recipients of list ORACLE-L
Subject:How to get rid off certain character from a string ???
Hi all,
How to get rid off certain character from a string.
For example, I have string 'WC_89_06_03', what's an
easy way to get 'WC890603' out