topic Re: Regarding LIKE statement in SELECT query in Application Development and Automation Discussions

Regarding LIKE statement in SELECT query

Former Member — Wed, 28 Nov 2007 04:25:24 GMT

Hi,

I am having a select-option s_job in my selection-screen.

In the program in select query i am writing condition in where as below:

Select * INTO t_tbt

FROM tbtco

WHERE status EQ 'R' AND

jobname IN s_job.

Now as per new requirement i can give s_job input as Z122*, so as per that i need to change select query.

how can i change query?

If i change where condition to jobname LIKE 's_job%' will that be fine.

Please clarify!

Thanks,

Deep.

Re: Regarding LIKE statement in SELECT query

Former Member — Wed, 28 Nov 2007 04:29:45 GMT

no need to change the query if you are giving input Z122* in your select option s_job then your query will work fine.

Select * INTO t_tbt

FROM tbtco

WHERE status EQ 'R' AND

jobname IN s_job.

Only think you can not give range like z122* to z140* in your select option. Only single value is allowable for pattern.

regards

shiba dutta

Re: Regarding LIKE statement in SELECT query

former_member189059 — Wed, 28 Nov 2007 04:33:56 GMT


data: lv_temp(50). " put one more than your job variable size

Loop at s_job.

concatenate s_job-low '%' into lv_temp

Select * appending table t_tbt
FROM tbtco
WHERE status EQ 'R' AND
jobname like lv_temp.

endloop.