How can I print all data that contains a required single word not.

[Guest]

How can I print all data that contains a required single word not the whole
field.

We want to extract the whole data that contains our required word, the
FILTER option can be used but it fiters the data by Whole Field but not by
the single word.

We want to filter the data by a single word and print them out.

Please reply soon...

 

[Guest]

It sounds like you want something like:

select <data value> from <your table>
where <data value> LIKE "%" & [Word To Match] & "%"

This will look for data that contains anything before and after the specific
word that you want to match and returns the entire value. In the QEB, specify:

LIKE "*"&[Word To Match] & "*"

on the Criteria line for the field.