How about the REPLACE function?
See http://www.postgresql.org/docs/7.4/interactive/functions-string.html
John Sidney-Woollett
Victor Spång Arthursson wrote:
> I have looked in the manual, but can't find a function to use in SQL
> which replaces chars/strings with given ones…
>
> For example; replace all a with b in the field testfield…
>
> Anyone?
>
> Sncerely
>
> Victor
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>