How to get rid off certain character from a string ???

2002-09-06 Thread Janet Linsy
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

RE: How to get rid off certain character from a string ???

2002-09-06 Thread Jamadagni, Rajendra
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

Re: How to get rid off certain character from a string ???

2002-09-06 Thread Viral Desai
-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

RE: How to get rid off certain character from a string ???

2002-09-06 Thread Karniotis, Stephen
, 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