Re: select works and not.

There may be characters that don't show in the data. Such as two blanks.
Maybe you can isolate it by doing your like clause something like
'...1031%CHIA' then '...1031%BARNECHIA'...
Corrections welcome

On Dec 6, 2017 8:23 PM, "Gonzalo V" <gvm2121(at)gmail(dot)com> wrote:

Good day
please i need help on this search, i am stuck by days!

select * from ventasprueba v
where v."DIRECCION" like 'AVDA. LA DEHESA #1445
<https://maps.google.com/?q=AVDA.+LA+DEHESA%C2%A0+%231445&entry=gmail&source=g>,
LOCAL 1031, LO BARNECHEA'
it gives me nothing.
but if i delete ,LO BARNECHEA

select * from ventasprueba v
where v."DIRECCION" like 'AVDA. LA DEHESA #1445
<https://maps.google.com/?q=AVDA.+LA+DEHESA%C2%A0+%231445&entry=gmail&source=g>,
LOCAL 1031%'
it works!.
i need to make that select with the complete string but it doesnt work.
can you help me

Saludos,
Gonzalo