Skip to main content
  • EN
Hi,

 

 

I want to query records of table A where the value of X contain value of Y in table B:

 

select * from A,B where X LIKE '%Y%'

 

It output nothing, I think the problem is the quote make Y into a normal string.

 

 

How to solve this?

 

 

Thanks

 

 
Hi,

 

 

Characters within single quotes will be interpreted literally. I think this statement generates your intended result.

 

-----

 

select * from A,B where X like '%'||Y||'%'

 

-----

 

 

Takashi
Hi,

 

 

Thank you, Takashi. It works.

 

 

I just find the search result of Knowledge Center is different from Communit Answers. I didn't find your last answer when I search with the toolbar of Knowledge Center.

Reply


Community Stats

30,108
Posts
114,295
Replies
37,744
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.