Re: Removing blank spaces from a column ?

From: Paul Q <paulq_at_home.com>
Date: Wed, 04 Oct 2000 21:39:02 GMT
Message-ID: <WrNC5.82976$dZ2.31675923@news3.rdc1.on.home.com>

.
update table
set field_name=replace(field_name,' ',null);

"Matt" <zagnimp_at_aom.bt.co.uk> wrote in message news:39DB51C8.5EA44A9D_at_aom.bt.co.uk...
> Hi
>
> Is there a function/procedure plsql command
> for removing blank spaces from a column ?
>
> ie I would like to remove all the blank spaces
> from the following column...
>
> 12 12 12 12 12 to make 1212121212
>
> Regards
>
> Matt
>
Received on Wed Oct 04 2000 - 16:39:02 CDT

This message: [ Message body ]
Next message: Roy Osborn: "Report Generation: Excel or Oracle?"
Previous message: Stephan Born: "Re: Removing blank spaces from a column ?"
In reply to: Matt: "Removing blank spaces from a column ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US