Question:
I need to filter a query so that the E3Browser will display all results that contain the letter combination of the typed value, in any part of its text. How can I do this?
Solution:
To do so, use LIKE command and “%” wild card, according to the following example:
SELECT *
FROM TableX
WHERE TableX.Field LIKE “%<%variable%>%”
However, notice that only in this type of query the single quotation marks should be removed. You should always use the syntax ‘<%variable%>‘ when using a string variable in SQL.
Check the related articles for more explanations about queries.
NOTE: the demo application was developed with E3 v3.2 b238.
Related articles
Attachments:
