How can I remove parentheses in a database field ?

From: <bdimple_at_my-deja.com>
Date: Tue, 28 Nov 2000 18:43:13 GMT
Message-ID: <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 Tue Nov 28 2000 - 19:43:13 CET

Original text of this message