Re: String - replacing multiple spaces

May be that way :

select replace(replace(replace('Billy Bob Smith',' ',' '),' ',' '),' ',' ') from dual;

Jerome Chik wrote in message <3675D903.1012_at_citec.com.au>...
>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.

Received on Thu Dec 17 1998 - 01:40:21 CST