Here I'm trying to perform LIKE operation in SOQL when I'm passing a variable dynamically the Query is not returning the results?
List<string> companies=new list<string>(); List<Account> leadAccountIds=[Select Id, OwnerId, Name FROM Account WHERE Name LIKE : '%' + companies + '%'];
I tried Like below ways
LIKE '%+ companies +%' LIKE: '%companies %' LIKE:('%'+companies+'%')
Please help me?
Thanks In Advance!...