>>> Naomi Walker <nwalker@xxxxxxxxxxxxxxx> wrote: > Is there some way with a SQL state to interrogate a text field, and > replace characters. > > For example, we would like all "|"'s to be changed to something else, on > a regular basis... It sounds like you might want to look at the regexp_replace function: http://www.postgresql.org/docs/8.3/interactive/functions-matching.html#FUNCTIONS-POSIX-REGEXP Be sure to use a WHERE clause on your UPDATE with the ~ operator. -Kevin
