https://community.sap.com/t5/additional-q-a/flexible-search-query/qaa-p/12343454#M155085 <P>i have found a solution to fix this in flexible query as well like below</P><P>select * from table where {attribute} like '%\_test%' escape '\'</P> Tue, 23 Mar 2021 21:00:52 GMT former_member737102 2021-03-23T21:00:52Z https://community.sap.com/t5/additional-q-a/flexible-search-query/qaq-p/12343453 <P>how to add underscore in flexible search query as underscore does not work in oracle like clause and if it is oracle query we can add something like below but how can we do that in flexible search query</P> <PRE><CODE>&lt;code&gt;SELECT * FROM TABLE1 WHERE NAME LIKE 'test\_1%' escape '\'</CODE></PRE> Tue, 23 Mar 2021 19:53:00 GMT https://community.sap.com/t5/additional-q-a/flexible-search-query/qaq-p/12343453 former_member737102 2021-03-23T19:53:00Z https://community.sap.com/t5/additional-q-a/flexible-search-query/qaa-p/12343454#M155085 <P>i have found a solution to fix this in flexible query as well like below</P><P>select * from table where {attribute} like '%\_test%' escape '\'</P> Tue, 23 Mar 2021 21:00:52 GMT https://community.sap.com/t5/additional-q-a/flexible-search-query/qaa-p/12343454#M155085 former_member737102 2021-03-23T21:00:52Z