Skip to Content
0
Former Member
Nov 15, 2012 at 06:00 AM

Select statement with wildcard dynamically

2275 Views

Hi all,

i need to fetch data with wildcards dynamically. pls help.

SELECT * FROM z_ppc_kat INTO TABLE lt_ppc_kat
WHERE qmart = 'QI' AND
qkatart = '8' AND
qcodegrp LIKE 'Q%'.

but the value of Q in the above statement is static, but in my requirement this value is dynamic.

pls help, how can we usage wildcars dynamically.

Best Regards,

Venkat