On Fri, Nov 14, 2008 at 12:17 PM, paulo matadr <[EMAIL PROTECTED]> wrote:
>
> I Need to replace string (" ) in the situation below :
>
> select clie_nmclientefrom cadastro.cliente where clie_nmcliente like
> '%"%';
>
> result:
> JOANA D"ARCALMEIDA"
> EMLURB "P M R."
> CECILIA D"CAGNO"
> HELENA
On 14/11/2008 16:17, paulo matadr wrote:
> Any help me to create pgPL/sql or funcion to replace ( " ) to null
> value, I have many table with this.
Do you mean you want to replace just those characters with NULL? Won't
this cause the entire string to be NULL?
postgres=# select 'abc' || NULL;
I Need to replace string (" ) in the situation below :
select clie_nmclientefrom 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 SO
