Hi experts,
I have to look for employees in the table PA0002 by name and first name.
I need that the searching without taking into account the accents, for example the results for 'JUAN' and 'JUÁN' must be the same.
Rigth now I have the following code:
data l_nombre type string.
l_nombre = 'JUAN'
and in PA0002 I have an employee whose name is JUÁN
if I do
select *
from pa002
where vorna like l_nombre.
I get 0 matches and I shouid get the the employee 'JUÁN'.
Thanks.