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,
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 an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, 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 an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, 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.
- 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.