Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Using like queries in query template with dynamic search values

Hi,

Following is my query syntax to search the items in Oracle data base

select * from xyz where material like '%' || search value|| '%'.

But I am not able to write the search query in query template using [Param.1] to dynamically pass the search value.

I have tried the following syntax which is throwing execptions.

select * from xyz where material like '%' & [Param.1] & '%'.

Any help in this regard is very much appreciated.

Thank you,

Kola

Former Member
Former Member replied

Hi Rajendra,

Try this : select * from xyz where material like '%[Param.1]%'

This will work.

Thanks,

Sushma.

<<Request for points removed>>

Message was edited by:

Abesh Bhattacharjee

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question