Re: String - replacing multiple spaces

Jerome Chik schrieb:
>
> Hi,
>
> Is there a way in PL/SQL to remove multiple spaces in a string and
> replacing them with a single space?
>
> e.g. "Billy Bob Smith" into "Billy Bob Smith"
>
> Thanks,
>
> Jerome.

Shouldn't it go this way:

UPDATE
        your_table
SET
        your_field=REPLACE(your_field, ' ', ' ') ;

HTH
Matthias
--
Matthias.Gresz_at_Privat.Post.DE

Always log on the bright side of life.
http://www.stone-dead.asn.au/movies/life-of-brian/brian-31.htm Received on Tue Dec 15 1998 - 01:18:09 CST