Where

[Former Member]

Hi,

How can I do this in ABAP ??

In Pseudocode:

select name,surname

from table

where name like %John%

How is the code in ABAP to the sentence where ?? (like)

Thanks

[Former Member]

TRY

select name,surname

from table

where name like '%John'

[Former Member]

and if 'John' isnt a constant ??

[Former Member]

say v_name is the variable which contians the name.

CONCATENATE '%' v_name INTO v_name.

then use WHERE name LIKE v_name