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
Solved
quote in InlineQuerier
+1- Contributor
Hi,
Best answer by takashi
Hi,
View original
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
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+19- Contributor
- Best Answer
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
+1- Contributor
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.
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.