[GENERAL] Enc: Help to replace caracter

[Database Administrator]

I Need to replace string (" ) in the situation below :

select clie_nmcliente from cadastro.cliente where clie_nmcliente like '%"%';

result:
JOANA D"ARCALMEIDA"
EMLURB "P M R."
CECILIA D"CAGNO"
HELENA FERREIRA D"FREITAS"
JOSE M. "BARRACA DO BOLA"
FORTE" DUNAS BAR"
JOANA D"ARC R. DE SOUZA
ASSEMBLEIA DE DEUS"
USINA SALGADO"SUPRIMENTO
JOSE MOURA 'BIGODE"
BEATRIZ MEDEIROS D"EMERY

Any help me to create pgPL/sql or funcion to replace ( " ) to null value, I have many table with this.
Thanks for help



Veja quais sãoos assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com