Re: Deleting Double spaces in a Field

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 Fri Jan 10 2003 - 08:35:17 CST