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, 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, LOCAL 1031%'
it works!.
i need to make that select with the complete string but it doesnt work.
can you help me
Saludos,
Gonzalo