Using Like Operator in Execute Query

Hi,
How can I write this sql query in Execute Query in uipath

from DB—Select * from xyz where [Domain_Name] =‘abc.abc’ and [Agency] like ‘%xyz%’

in Uipath----“Select * from xyz where [Domain_Name] =’”+DomainName(1)+"’ and [Agency]=’"+strNewAgency+"’"

eg; My strNewAgency has data ‘abc xyz qwerty’ in the db

@Neha_Singh2111

Welcome to Community!

"Select * from xyz where [Domain_Name] ='"+DomainName(1)+"' and [Agency] Like'%"+strNewAgency+"%'"
1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.