try translate():
select translate('Mary Margaret Smith',' ','_');
translate
---------------------
Mary_Margaret_Smith
Cheers,
Steve
On Wednesday 29 January 2003 9:09 pm, ryanne cruz wrote:
> hi list!
>
> i have a column wherein a lot of entries has 2 or more names int it. these
> are separated by spaces. an example is: "John Doe", "Mary Margaret Smith".
> i need to replace the spaces with an underscore. any idea how to do this?
>
> thanks!
>
> ryanne
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org