Re: String - replacing multiple spaces

You can try this command...

update sqlarea_text set sql_text = replace(lower(sql_text) ,’abstract_ ’,’ abstract_ ’);

I think it should work (no guarantees!)

Joel R. DeRider
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 Tue Dec 15 1998 - 07:49:43 CST