Re: Deleting Double spaces in a Field

Remember that this will only catch double spaces, not triple ect. You would have to run it several times if you also have triple spaces etc.

zp

"Peter van Rijn" <p.vanrijnREMOVE_at_THISzhew.nl> wrote in message news:v1tmjhplau05e9_at_corp.supernews.com...
> update company
> set name=replace(name, ' ', ' ')
>
> hth,
> Peter
>
> "DominiqS" <dominiqs_at_o2.co.uk> schreef in bericht
> news:1042202523.837019_at_ernani.logica.co.uk...
> > All,
> > Quick question how do i delete a double blank space from a table called
> > company and the field or row where the blank spaces need to be deleted
is
> > name ie company name .
> > There is an extra blank space in between the company names eg
> > My Own Company (one with double space)
> > My Own Company (one with single space) normal.
> > I have run a sql to identify the 166 rows that have this problem now i
> need
> > a quick way of resolving this problem ie deleteing the extra space from
> > these rows.
> > Any help would be greatly appreciated.Thanks
> > We are running Oracle 817 on Solaris 8.
> >
> > I have about 166 rows affected by this double space problem,Is there a
> fast
> > way of doing it or even a script to take care of this
> >
> >
>
>
Received on Sat Jan 11 2003 - 20:14:56 CST