Question

3
Replies
943
Views
ArpanP77 Member since 2018 9 posts
Texas Commission On Environmental Quality
Posted: 2 years ago
Last activity: 2 years 1 month ago
Closed
Solved

Using Like keyword in Connect SQL query

Hello,

Hope everybody is doing good.

I have a requirement where I want to find all results from database containing string entered by user. My primary goal is to achieve similar functionality of "Contains" as in Obj-Browse. Do we need to put any symbol to make "like" keyword work? I have tried following and none of them seems to work.

.LegalName is a property in which I am storing user input and using it in a query to compare against column LEGAL_NAME from DB.

1. WHERE ((T1.LEGAL_NAME like {.LegalName}) OR ({.LegalName} IS NULL))

2. WHERE ((T1.LEGAL_NAME like '%{.LegalName}%') OR ({.LegalName} IS NULL))

3. WHERE ((T1.LEGAL_NAME like {'%.LegalName%'}) OR ({.LegalName} IS NULL))

4. WHERE ((T1.LEGAL_NAME like {%.LegalName%}) OR ({.LegalName} IS NULL))

Kindly let me know if you need additional information from my end.

Your help is really appreciated. TIA

Regards,

Arpan Parikh

Data Integration
Moderation Team has archived post
Share this page LinkedIn