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 - 06:42:02 CST
