Integration

Hi,

In one ESB i'm using Database adapter to read the data from the DB.

here my requirement is to use like operator.

the query is like below it is getting generated

SELECT ID, NAME, EMAIL, PHONE FROM CUSTOMER WHERE (EMAIL LIKE #search-string)

here the search-string is i/p paramter

I have tried like SELECT ID, NAME, EMAIL, PHONE FROM CUSTOMER WHERE (EMAIL LIKE %#search-string %)

I have tried like SELECT ID, NAME, EMAIL, PHONE FROM CUSTOMER WHERE (EMAIL LIKE #%search-string% )

but it is not working

Please help me out