Thread: remove too much space between words of the string

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???

Thank you.

Regards,

akbar

On Wed, Dec 01, 2004 at 18:18:41 +0700,
  Akbar <melinda_sayang@hotpop.com> 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.