String - replacing multiple spaces

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 Mon Dec 14 1998 - 21:35:31 CST