Re: remove too much space between words of the string

On Wed, Dec 01, 2004 at 18:18:41 +0700,
  Akbar  wrote:
> Assume I have this string: 'bla                 bla'. Is there any 
> function to make that string to become: 'bla bla'. Or do I have to make 
> the function manually???

You need to write a function to do this.

Usually I do this kind of processing before trying to store the data in
the database and use a constraint to enforce that there aren't
consecutive blanks.