Re: using wildcards with REPLACE
From: PT <g_abhi_at_yahoo.com>
Date: Thu, 7 Jun 2001 10:27:16 -0400
Message-ID: <9fo20j$bkc10_at_kcweb01.netnews.att.com>
Date: Thu, 7 Jun 2001 10:27:16 -0400
Message-ID: <9fo20j$bkc10_at_kcweb01.netnews.att.com>
I don't think you can use wildcards with "REPLACE" , but this might help
Try:
HTH
"knight" <nospam_at_newsranger.com> wrote in message
news:FbLT6.2221$bA3.107560_at_www.newsranger.com...
select translate('abcd<123>ABCD','<>',' ') from dual;
PT
> Hi,
>
> Can anyone tell me if wildcards are possible when using replace, eg:
>
> replace('mystring','<*>','')
>
> to remove all HTML formatting?
>
> Cheers,
>
> K
>
>
Received on Thu Jun 07 2001 - 16:27:16 CEST