Re: Newbie
From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Sun, 10 Nov 2002 07:41:33 -0000
Message-ID: <3dce0db0$0$8511$cc9e4d1f_at_news.dial.pipex.com>
Date: Sun, 10 Nov 2002 07:41:33 -0000
Message-ID: <3dce0db0$0$8511$cc9e4d1f_at_news.dial.pipex.com>
[Quoted] I wonder , in MSSQL you can do a REPLACE, could it be possible that there is [Quoted] a REPLACE statatement supported by Oracle? If there is maybe its in one of the manuals.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "tou" <tou_at_tou.tou> wrote in message news:aqe9hc$q7u$1_at_nsnmpen2-gest.nuria.telefonica-data.net...Received on Sun Nov 10 2002 - 08:41:33 CET
> Hi,
>
> I need to make changes to telephone #'s in a field and I don't know what
> tool I need to use...
>
> In Access or MS SQL I select column, go to Edit and I choose Replace
> Option.. As easy as that...
>
> In fact I need to erease all spaces, dots, etc.
>
> TIA
>
>