topic Re: Where in Application Development and Automation Discussions

Where

Former Member — Thu, 22 May 2008 17:43:31 GMT

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 — Thu, 22 May 2008 17:45:49 GMT

TRY

select name,surname

from table

where name like '%John'

Former Member — Thu, 22 May 2008 17:58:13 GMT

and if 'John' isnt a constant ??

Former Member — Thu, 22 May 2008 19:00:51 GMT

say v_name is the variable which contians the name.

CONCATENATE '%' v_name INTO v_name.

then use WHERE name LIKE v_name