Skip to Content
0
Jun 02, 2011 at 04:23 PM

Search

99 Views

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.