Re: How can I remove parentheses in a database field ?
From: Ivar Stolfot <Ivar.Stolfot_at_mail.ee>
Date: Wed, 29 Nov 2000 11:08:58 +0200
Message-ID: <3a24c7ba$0$28964_at_diablo.uninet.ee>
Date: Wed, 29 Nov 2000 11:08:58 +0200
Message-ID: <3a24c7ba$0$28964_at_diablo.uninet.ee>
Don't no about theory but in Oracle SQL it looks like this:
UPDATE table1 SET some_text_column =
REPLACE(REPLACE(some_text_column,'(',''),')','');
or
UPDATE table1 SET some_text_column = TRANSLATE(some_text_column,'X()','X');
<bdimple_at_my-deja.com> wrote in message news:900ubv$6c1$1_at_nnrp1.deja.com...
> Hi,
>
> How can I remove parentheses in a database field ?
> For example, with this data :-
>
> (ma12345) or ia23(jsj)
> I would like the result to be :-
> result= ma12345 or ia23jsj
>
> I will really appreciate any suggestions.
>
> TIA
>
> B.Dimple
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Nov 29 2000 - 10:08:58 CET